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...
Hey Guys,
Great looking forum, hope you can help me with this. I am trying to do a GROUP BY, but not having much luck.
SELECT `tblAttraction`.`AttractionName`, max(`tblAttraction`.`AttractionCapacity`), `tblAttraction`.`AttractionMinAge`, `tblThemePark`.`ParkName`
FROM `tblThemePark`
LEFT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.