SELECT COUNT(*)
FROM table_name
WHERE strftime('%Y', date_column) = '2022';
SELECT SUM(amount)
FROM table_name
WHERE strftime('%m', date_column) = '01';
SELECT *
FROM table_name
WHERE strftime('%Y-%m-%d', date_column) = '2022-01-01';
SELECT AVG(amount)
FROM table_name
WHERE strftime('%H', date_column) >= 12;
