Q&A for Joomla! administrators, users, developers and designers
SELECT CAST(CreationDate AS Date) PostDate, COUNT(*) FROM Posts P WHERE CreationDate > '2020-12-01' AND Tags LIKE '%pycharm%' AND ClosedDate IS NOT NULL AND PostTypeId = 1 GROUP BY CAST(CreationDate AS Date) ORDER BY CAST(CreationDate AS Date)