-- [SQL-2-1-2-a]
EXPLAIN
SELECT t1.pay_tp ,COUNT(*) ord_cnt
FROM startdbpg.tr_ord t1
INNER JOIN startdbpg.ms_shop t2 ON (t2.shop_id = t1.shop_id)
WHERE t1.ord_dtm >= '2024-01-01'::date
AND t1.ord_dtm < '2024-02-01'::date
GROUP BY t1.pay_tp;
SQL
복사