SQL | SOLVESQL 코딩테스트 : Lv2. (SELECT)

Lv2. 레드 와인 도수와 퀄리티

https://solvesql.com/problems/alcohol-degree-and-quality/

SELECT * 
FROM wines
WHERE quality >= 8
  AND alcohol <= 12
  AND color = 'red'
ORDER BY quality DESC, alcohol ASC

 

Lv2. 보상 고객 목록입니다

https://solvesql.com/problems/compensated-customers/

SELECT order_date, order_id, customer_name
FROM orders
WHERE order_date BETWEEN '2018-04-01' AND '2018-04-05'
ORDER BY order_date ASC, order_id ASC

 

Lv2. 팁 많이 준 고객들의 특징

https://solvesql.com/problems/high-tipping-customer/

SELECT total_bill, tip
  , ROUND(tip / total_bill*100,2) as tip_ratio
  , sex
  , smoker
  , size
FROM tips
WHERE total_bill >= 30
ORDER BY tip_ratio DESC