BR><BR>My question is how to write an SQL query (using MySQL 3.23.58) that finds the least expensive vendor for every hotel room in the table? So if ten different vendors offer rooms at the ...

The MySQL Workbench main ... the SCHEMAS pane and select Create Schema. Figure A Once you name your schema, click the Apply button and, when prompted, review the SQL Script and click Apply again.