ד
SELECT Customers.[Last Name], Customers.[First Name], Customers.[Job Title],Count(*) As NumOrders FROM Customers Inner JOIN Orders ON Customers.ID = Orders.[Customer ID] Where Customers.[Job Title] like '*Manager' AND Customers.[city] In ('New York','Miami','Chicago') Group By Customers.[Last Name], Customers.[First Name], Customers.[Job Title]
SELECT Customers.[Last Name], Customers.[First Name], Customers.[Job Title],Count(*) As NumOrders FROM Customers Inner JOIN Orders ON Customers.ID = Orders.[Customer ID] Where Customers.[Job Title] like '*Manager' AND Customers.[city] In ('New York','Miami','Chicago') Group By Customers.[Last Name], Customers.[First Name], Customers.[Job Title]