How to write this SQL Query (Hotels, Rooms, and Rates)? ... Its my understanding that MySQL doesn't support all of SQL92 - specifically I don't know how it deals with temp tables.

The latest release of SQL Diagnostic Manager for MySQL helps reduce cloud costs by enabling more efficient queries. In addition, enterprise security for MySQL and MariaDB databases is critical to ...