This assignment is meant to assess your ability to JOIN data using SQL.

EJ Gallo wants to see how many employees work at each vineyard, but they want this summary table to use the vineyard name (rather than ID number). Type a query that appends the name of the vineyard that each employee works at to the 'employee' table. Then, group the result in a way that shows the NUMBER of employees that work at each vineyard (call this column 'employee_count'). Your result should have two columns: VineyardName and employee_count.