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

 

 

RecreationalFacility X ParkID Name Permit X 3 Griffith Park 1 Balboa Park Location Park X Conce - Concession! . 4730 Crystal Sp 3010 5651 Balboa Bly BT10 7 Various Various GP 6 Griffith Observ 2800 E Observa GP10 6 Griffith Observ 2800 E Observa GP11 3 Griffith Park 2333 Fern Dell GP14 6 Griffith Observ 2800 E Observa GP15