MySQL - find seasonality in the rate change - Asked By Cherifa Hima on 31-Jul-13 05:55 PM

I need to grab five columns from a database : resortid, roomid, date, rate1, and rate2 where resortid can have many roomid.

1. I need first to grab from the database all five columns by selecting only the roomid that has the lowest rate1 per resort.

2. I need then to know which dates rate1 change within a resort for that lowest room since rates can change weekly, monthly, or less ( add a column).

3. I need then to know which dates rate2 change within a resort for that lowest room ( add a column).