Report showing totals of rooms sold per room type with totals

A report that shows each room type and the amount of time it has been sold, per day, per month and per year

requested by Inn by the Se La Jolla