SQL52 Hacker rank Population Density Difference 1 2 select max(population)-min(population) from city cs 2021. 10. 21. Hacker rank Japan Population 1 2 3 select sum(population) from city where countrycode='jpn' cs 2021. 10. 21. Hacker rank Average Population 1 2 select round(avg(population)) from city cs 2021. 10. 21. Hacker rank -Revising Aggregations - Averages 1 2 3 select avg(population) from city where district ='California' cs 2021. 10. 21. Hackerrank Revising Aggregations - The Sum Function 1 2 3 select sum(population) from city where district='California' cs 2021. 10. 21. Hacker rank Revising Aggregations - The Count Function 1 2 3 select count(name) from city where population>100000 cs 2021. 10. 21. Hacker rank African Cities 1 2 3 4 select city.name from city join country on city.countrycode=country.code where country.continent='Africa' cs 2021. 10. 21. Hacker rank Population Census 1 2 3 4 5 select sum(city.population) from city join country on city.countrycode=country.code where country.continent='Asia' cs 2021. 10. 21. Hacker rank Employee Salaries 1 2 3 4 select name from employee where salary >2000 and months 2021. 10. 21. Hacker rank Employee Names 1 2 3 select name from employee order by name cs 2021. 10. 21. Hacker rank Higher Than 75 Marks 1 2 3 4 select name from students where marks>75 order by right(name,3) , id cs 2021. 10. 21. Hacker rank Weather Observation Station 12 1 2 3 4 5 select distinct city from station where left(city,1) not in ('a','e','i','o','u') and right(city,1) not in ('a','e','i','o','u') cs 2021. 10. 21. 이전 1 2 3 4 5 다음
Hacker rank Weather Observation Station 12
1 2 3 4 5 select distinct city from station where left(city,1) not in ('a','e','i','o','u') and right(city,1) not in ('a','e','i','o','u') cs
2021. 10. 21.
