Need help fixing SQL code. I want code to retrieve the number of concessionaires for each park
Fantastic news! We've Found the answer you've been seeking!
Question:
Need help fixing SQL code. I want code to retrieve the number of concessionaires for each park by joining the Park and Concessionaire tables and grouping the results by the park's name.
This is my code:
SELECT Park.Name, COUNT(*) AS NumberOfConcessionaires FROM (Park INNER JOIN Concessionaire ON Park.ParkID = Concessionaire.ParkID) GROUP BY Park.Name;
Here our the tables
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: