Count group by date

PHOTO EMBED

Sat Mar 05 2022 19:27:18 GMT+0000 (Coordinated Universal Time)

Saved by @technoking #database

SELECT count(*) as application, YEARWEEK(created_date) as weekNum
FROM nepaldevjobsapplication
GROUP BY YEARWEEK(created_date)
content_copyCOPY