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

Lv1. 모든 데이터 조회하기

https://solvesql.com/problems/select-all/

SELECT *
FROM points

 

Lv1. 일부 데이터 조회하기

https://solvesql.com/problems/select-where/

SELECT *
FROM points
WHERE quartet = 'I'

 

Lv1. 데이터 정렬하기

https://solvesql.com/problems/order-by/

SELECT *
FROM points
WHERE quartet = 'I'
ORDER BY y ASC

 

Lv1. 우리 레스토랑에 온 부자 손님

https://solvesql.com/problems/rich-customer/

SELECT day, time, size
FROM tips
ORDER BY total_bill DESC
LIMIT 1

 

Lv1. 평점 높은 영화 찾기

https://solvesql.com/problems/find-high-rated-movies/

SELECT title, year, age, imdb, rotten_tomatoes
FROM movies
WHERE YEAR = 2020
  AND netflix = 1
  AND (imdb >= 9.0   OR rotten_tomatoes >= 90)

 

Lv1. 한강 근처 따릉이 대여소 찾기

https://solvesql.com/problems/bike-station-with-han-river/

SELECT station_id, name, local, address
FROM station
WHERE local = '광진구' 
      or local ='동작구' 
      or local ='마포구' 
      or local ='성동구' 
      or local = '영등포구'

 

Lv1. 특정 컬럼만 조회하기

https://solvesql.com/problems/select-column/

SELECT x, y
FROM points

 

Lv1. 몇 분이서 오셨어요?

https://solvesql.com/problems/size-of-table/

SELECT *
FROM tips
WHERE MOD(size,2) = 1

❗MOD() 사용해서 SIZE를 2로 나눈 나머지로 조건 걸기

 

Lv1. 화이트 와인 도수와 퀄리티

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

SELECT color, pH, alcohol, quality
FROM wines
WHERE quality >= 8
      and alcohol <= 12
      and color = 'white'

 

Lv1. 여자 양궁 선수들의 BMI 지수 구하기

https://solvesql.com/problems/bmi-of-women-archery/

SELECT athlete_id
  , medal
  , sex
  , weight
  , height
  , ROUND((weight / POWER(height/100,2)),2)AS bmi
FROM records
WHERE game_id = 49
  AND event_id = 39

 

Lv1. 레스토랑의 영업일

https://solvesql.com/problems/restaurant-business-day/

SELECT DISTINCT day AS day_of_week
FROM tips

❗겹치지 않아야 하므로 DISTINCT 사용

 

Lv1. 영어로 볼 수 있는 장편 영화

https://solvesql.com/problems/feature-film-in-english/

SELECT * 
FROM movies
WHERE runtime >= 200
  AND directors IS NOT NULL
  AND language LIKE '%English%'
ORDER BY year DESC, title ASC