DAY

1
SELECT
2
  event_date,
3
  DAY(event_date) as day_of_month,
4
  MONTH(event_date) as month
5
FROM events;

1
SELECT *
2
FROM transactions
3
WHERE DAY(transaction_date) IN (25, 26, 27)
4
  AND category = 'Salary';

1
SELECT
2
  DAY(order_date) as day_of_month,
3
  COUNT(*) as order_count,
4
  AVG(amount) as avg_order_value
5
FROM orders
6
GROUP BY DAY(order_date)
7
ORDER BY order_count DESC
8
LIMIT 5;