SQL

230711 공부

주스 JUICE 2023. 7. 11. 22:56
728x90


230711 공부
해커랭크 문제풀이
 
Weather Observation Station 11
Weather Observation Station 12

 

[해커랭크] Weather Observation Station 11&12

이전 문제 응용 Weather Observation Station 11 https://www.hackerrank.com/challenges/weather-observation-station-11/problem Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com s

datajuice.tistory.com

 
Higher than 75 Marks

 

[해커랭크] Higher Than 75 Marks

https://www.hackerrank.com/challenges/more-than-75-marks/problem 문제 푼 방식 1. query the name -> select name 2. students 테이블 -> from students 3. 75보다 marks 필드 높아야 함 -> where makrs > 75 4-1. 마지막에서 세번째까지의

datajuice.tistory.com

 
 
Employee Names

 

[해커랭크] Employee Names

아주 간단한 문제.. https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true Employee Names | HackerRank Print employee names. www.hackerrank.com select name from employee order by name asc

datajuice.tistory.com

 

728x90