SELECT count(*) as order_count FROM study_tbl as a left outer join order_tbl as b on a.order_no = b.order_no WHERE a.user_id = '' and ('2021-03-02' between a.study_sdate and a.study_edate ) and b.order_type = '3'
¼ö¾÷ÁøÇà, ÄÚ¸àÆ® ¹Ú½º°ü·Ã, ±³Àç ¹× ¼ö¾÷°ú °ü·ÃµÈ °£´ÜÇÑ ¿äû»çÇ×À» °»ç¿¡°Ô Á÷Á¢ ¿äû ÇÒ ¼ö ÀÖ½À´Ï´Ù. |
Ãß°¡ÀûÀ¸·Î ¿äû»çÇ×ÀÌ ÀÖÀ»°æ¿ì 300ÀÚ À̳»·Î ³»¿ëÀ» Àû¾î ÁÖ¼¼¿ä. (¿äû ³»¿ëÀº ´ã´ç°»ç°¡ È®ÀÎÇϸç, °Ô½ÃÆÇ¿¡ º°µµ ´äº¯À» µå¸®Áö ¾Ê½À´Ï´Ù.) |
![]() |