Untitled

SELECT DATE_FORMAT(date_column, '%Y-%m') AS month, SUM(CASE WHEN other_column = 'P' THEN 1 ELSE 0 END) AS rolling_volume FROM your_table_name GROUP BY DATE_FORMAT(date_column, '%Y-%m') ORDER BY DATE_FORMAT(date_column, '%Y-%m');
Anonymous
plain_text
02/16/2024 7:42 AM
16 B
17
Indexable
qwenrnrjjej
Editor is loading...
Leave a Comment