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
 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Explanation This is a self join query that counts the number of subordinates for each employee The E... View the full answer