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.

Oracle has recently announced the general availability of MySQL 8.2, which includes support for Read/Write Splitting. This long-awaited feature has been introduced in the latest innovation release and ...