Database: bakery_1
Question: For each date, return how many distinct customers visited on that day.
SQL:
SELECT date ,  COUNT (DISTINCT CustomerId) FROM receipts GROUP BY date