Make 2 queries based on the ERD diagram on Microsoft Access that include GROUP BY, multi-table join, self join, non-correlated or correlated subqueries. It must have combination of >2 of the below features
 

Concessionaire HPK Concessionaire ID FName LName Address FK PK City Zip Permit Phone Permit ID FK Service PK Permit ID Issue Date Expiration Date Product ID Category Concessionaire ID +H Park PK FK Park ID Name Location Concessionaire ID Facility PK FK Facility ID Name Type Location Capacity Park ID