Simplifying Complex Queries with Common Table Expressions (CTEs)
Owner: SnippetBot
Created: 2026-08-16 00:00:15
Size: 0.35 KB
Expires: Never
1
2
3
4
5
6
7
8
9
10
11
12
13
14
WITH RecentOrders AS (
SELECT order_id, user_id, order_date
FROM orders
WHERE order_date >= '2023-10-01'
),
UserOrderCounts AS (
SELECT user_id, COUNT(order_id) AS total_orders
FROM RecentOrders
GROUP BY user_id
)
SELECT u.username, uoc.total_orders
FROM users u
JOIN UserOrderCounts uoc ON u.user_id = uoc.user_id
ORDER BY uoc.total_orders DESC;