Count the number of records per week
suggest changeSELECT date_trunc(‘week’, <>) AS “Week” , count(*)
FROM <>
GROUP BY 1
ORDER BY 1;
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents
SELECT date_trunc(‘week’, <>) AS “Week” , count(*)
FROM <>
GROUP BY 1
ORDER BY 1;