re: Way to go OT you are minimizing the seriousness of the COVID-19 situation in LA.

quote:

---

Except for the daily numbers that LDH has to sift through to take out the duplicates.

---

Sift through?

Here, let me help:

SELECT COUNT(DISTINCT id)
FROM covid_case_temp
WHERE covid = TRUE