I hope someone can help me build a MySQL query. I want to extract data from the database of the number of table reservations across all months in a specific year e.g. 2011.
All our table reservations from our nightclub is stored in a database table called reservations
Then we have the following fields:
I wonder if there is a smart way to count total reservations based on the ID and combine the date field with this graph from Google: https://google-developers.appspot.com/chart/interactive/docs/gallery/linechart
Thanks in advance!