sql-exercises / ex15.sql
ex15.sql
Raw
SELECT DailyStats.daterep, cases
FROM DailyStats
INNER JOIN DateInfo ON DailyStats.dateRep = DateInfo.DateRep
WHERE geoId = 'UK'
ORDER BY year ASC, month ASC, day ASC;