Q7-solution.sql

SELECT FirstName, LastName, COUNT(PurchaseId) AS cnt FROM Customers LEFT JOIN Purchases USING (CustomerId) GROUP BY FirstName, LastName ORDER BY FirstName, LastName DESC;