How to write this SQL Query (Hotels ... BR><BR>My question is how to write an SQL query (using MySQL 3.23. ... that works the same as the derived table, and use this in your query ...