공부/PS ( SQL)
-
[HackerRank/Basic Select] Weather Observation Station 5공부/PS ( SQL) 2022. 5. 15. 23:11
https://www.hackerrank.com/challenges/weather-observation-station-5/problem Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com 문제 풀이 SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ..
-
[HackerRank/Basic Select] Weather Observation Station 4공부/PS ( SQL) 2022. 5. 15. 22:48
https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com 문제 풀이 SELECT COUNT(CITY) - COUNT(DISTINCT(CITY)) FROM STATION
-
w3schools - sql exercise (1)공부/PS ( SQL) 2021. 11. 30. 01:04
SELECT * FROM Customers WHERE NOT CITY = 'Berlin' SELECT * FROM Customers ORDER BY Country, City 참고) SELECT * FROM table_name ORDER BY column1, column2 DESC column1 기준 오름차순 정렬 후 column2 기준 내림차순 정렬 INSERT Customers ( CustomerName, Address, City, PostalCode, Country ) VALUES ( 'Hekkan Burger', 'Gateveien 15', 'Sandnes', '4306', 'Norway' ) ; UPDATE Customers SET City = 'Oslo'; DELETE FROM Customers..
-
[HackerRank/Basic Select] Weather Observation Station 3공부/PS ( SQL) 2021. 9. 24. 01:29
https://www.hackerrank.com/challenges/weather-observation-station-3/problem Weather Observation Station 3 | HackerRank Query a list of unique CITY names with even ID numbers. www.hackerrank.com SELECT DISTINCT CITY FROM STATION WHERE ID MOD 2 = 0
-
[HackerRank/Basic Select] Weather Observation Station 1공부/PS ( SQL) 2021. 9. 24. 01:23
https://www.hackerrank.com/challenges/weather-observation-station-1/problem Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com SELECT CITY, STATE FROM STATION
-
[HackerRank/Basic Select] Japanese Cities' Names공부/PS ( SQL) 2021. 9. 24. 01:19
https://www.hackerrank.com/challenges/japanese-cities-name/problem Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com SELECT NAME FROM CITY WHERE COUNTRYCODE LIKE 'JPN'
-
[HackerRank/Basic Select] Japanese Cities' Attributes공부/PS ( SQL) 2021. 9. 24. 01:18
https://www.hackerrank.com/challenges/japanese-cities-attributes/problem Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com SELECT * FROM CITY WHERE COUNTRYCODE LIKE 'JPN'