SELECT d.Date AS AsOfDate, p.StateCode, p.StateName, p.ParishCode, p.ParishName, f.Cases, f.Deaths

FROM covid19.factJHCOVID19 f

INNER JOIN population.dimFIPSParish p

       ON p.FIPSParishKey = f.FIPSParishKey

INNER JOIN dbo.dimDate d

       ON d.DateKey = f.AsOfDateKey

ORDER BY AsOfDate ASC, f.Deaths DESC;