MSEE

SELECT TO_DATE(MODIFIEDTS) AS Modification_date, COUNT(P_CODE) AS Count_Articles
FROM PRODUCTS
WHERE P_CATALOG = ''8796093055576''
AND P_CATALOGVERSION = ''8796093088345''
AND MODIFIEDTS >= ADD_DAYS(CURRENT_DATE, -7)
GROUP BY TO_DATE(MODIFIEDTS)
ORDER BY Modification_date DESC