-- [SQL-2-1-3-1-a]
EXPLAIN
SELECT t1.ord_no ,t1.ord_dtm ,t1.shop_id
,(SELECT s1.shop_nm FROM startdbpg.ms_shop s1 WHERE s1.shop_id = t1.shop_id) shop_nm
FROM startdbpg.tr_ord t1
WHERE t1.ord_dtm >= '2024-01-01'::date
AND t1.ord_dtm < '2024-01-02'::date;
SQL
복사

