## **1. 要求如下圖** sql語句學習 https://www.nowcoder.com/ta/sql?from=baidusql&bd_vid=10130540574637136165  方案1 ``` select created_at, sum(case status when 1 then amount end) as 'total_1', sum(case status when 2 then amount end) as 'total_2' from orders group by created_at ```  方案2 ``` select sum(amount), created_at, status from orders group by created_at,status; ```  ## **2 mysql表關聯查詢** ``` SELECT lm_product_apply.*, lm_custom_made.* FROM lm_product_apply LEFT JOIN lm_custom_made ON lm_product_apply.user_id = lm_custom_made.user_id WHERE lm_product_apply.date = "2022-10-12" ```