문풀 ❓/SQL2 [HackerRank-SQL] Basic Select2 # Weather Observation Station 4 SELECT COUNT(CITY)-COUNT(DISTINCT CITY) FROM STATION # Weather Observation Station 5 SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1; # Weather Observation Station 6 SELECT CITY FROM STATION WHERE ( CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE '.. 2022. 1. 31. [HackerRank-SQL] Basic Select #1 Revising the Select Query1 SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION>100000 #2 Revising the Select Query2 SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000 #3 Select All SELECT * FROM CITY #4 Select By ID SELECT * FROM CITY WHERE ID = 1661 #5 Japnese Cities' Attributes SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN' #6 Japnese Cities' Name SELECT NAME FROM.. 2022. 1. 30. 이전 1 다음
