DAYOFWEEK

1
SELECT
2
  order_date,
3
  DAYOFWEEK(order_date) as dow_num,
4
  CASE DAYOFWEEK(order_date)
5
    WHEN 0 THEN 'Minggu'
6
    WHEN 1 THEN 'Senin'
7
    WHEN 2 THEN 'Selasa'
8
    WHEN 3 THEN 'Rabu'
9
    WHEN 4 THEN 'Kamis'
10
    WHEN 5 THEN 'Jumat'
11
    WHEN 6 THEN 'Sabtu'
12
  END as day_name
13
FROM orders
14
LIMIT 5;

1
SELECT
2
  CASE
3
    WHEN DAYOFWEEK(sale_date) IN (0, 6) THEN 'Weekend'
4
    ELSE 'Weekday'
5
  END as day_type,
6
  COUNT(*) as transaction_count,
7
  SUM(amount) as total_sales
8
FROM sales
9
GROUP BY day_type;

1
SELECT
2
  DAYOFWEEK(order_date) as day_num,
3
  COUNT(*) as orders,
4
  ROUND(AVG(amount), 0) as avg_order
5
FROM orders
6
GROUP BY DAYOFWEEK(order_date)
7
ORDER BY day_num;