-- [SQL-2-3-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.shop_id, COUNT(*) ord_cnt
FROM startdbpg.tr_ord_big t1
WHERE t1.ord_dtm >= '2025-01-01'::date
AND t1.ord_dtm < '2025-01-02'::date
GROUP BY t1.shop_id
ORDER BY ord_cnt DESC;
SQL
복사