Lv1. 많이 주문한 테이블 찾기
https://solvesql.com/problems/find-tables-with-high-bill/
SELECT *
FROM tips
WHERE total_bill > (SELECT AVG(total_bill)
FROM tips)
'SQL > SQL | SOLVESQL 코딩테스트' 카테고리의 다른 글
SQL | SOLVESQL 코딩테스트 : Lv2. (JOIN/UNION) (2) | 2024.10.23 |
---|---|
SQL | SOLVESQL 코딩테스트 : Lv2. (SELECT) (2) | 2024.10.23 |
SQL | SOLVESQL 코딩테스트 : Lv1. (STRING/DATE) (1) | 2024.10.22 |
SQL | SOLVESQL 코딩테스트 : Lv1. (AGGREGATE) (2) | 2024.10.22 |
SQL | SOLVESQL 코딩테스트 : Lv1. (SELECT) (0) | 2024.10.22 |