LeetCode / 1174. Immediate Food Delivery II / MySQL(Medium)
2023. 11. 29. 17:41
📚문제 📝풀이 # Write your MySQL query statement below SELECT ROUND(SUM(CASE WHEN order_date = customer_pref_delivery_date THEN 1 ELSE 0 END) / COUNT(*) * 100,2) AS immediate_percentage FROM Delivery WHERE customer_id, order_date IN (SELECT customer_id, MIN(order_date) FROM Delivery GROUP BY customer_id) WHERE구문 서브쿼리를 활용하여 풀었다 처음에는 order_date만 WHERE구문에서 필터링 해줬는데 Run Code에선 맞았는데 Submit에선 틀렸다고 나왔다 혹시 몰라..
