Hi Guys,
Thanks for the help with the last query, hopefully I am on my way to completing this now.
I need to make an QUERY to deduce the average ticket sales sold. As each ticket has a date assigned to it, i obviously first need to count the tickets and group them by the park name. I've done that, but in the same query, i need to then have it average the list it returns to show me the overall average. How would i go about doing that? Basically, it returns a list of each park and how many tickets they have sold, i need to provide an average for that list.
SELECT `tblThemePark`.`ParkName` , COUNT( `tblOrders`.`TicketID` )
FROM `tblThemePark`
JOIN `tblOrders` ON `tblThemePark`.`ParkID` = `tblOrders`.`ParkID`
GROUP BY tblThemePark.ParkName
Cheers
Thanks for the help with the last query, hopefully I am on my way to completing this now.
I need to make an QUERY to deduce the average ticket sales sold. As each ticket has a date assigned to it, i obviously first need to count the tickets and group them by the park name. I've done that, but in the same query, i need to then have it average the list it returns to show me the overall average. How would i go about doing that? Basically, it returns a list of each park and how many tickets they have sold, i need to provide an average for that list.
SELECT `tblThemePark`.`ParkName` , COUNT( `tblOrders`.`TicketID` )
FROM `tblThemePark`
JOIN `tblOrders` ON `tblThemePark`.`ParkID` = `tblOrders`.`ParkID`
GROUP BY tblThemePark.ParkName
Cheers