hackerrank(2)
-
[HackerRank MySQL] Symmetric Pairs
Symmetric Pairs You are given a table, Functions, containing two columns: X and Y. Two pairs (X1, Y1) and (X2, Y2) are said to be symmetric pairs if X1 = Y2 and X2 = Y1. Write a query to output all such symmetric pairs in ascending order by the value of X. List the rows such that X1 ≤ Y1. Sample Input Sample Output 20 20 20 21 22 23 Query select f1.x, f1.y from functions f1 inner join functions ..
2021.01.11 -
[HackerRank MySQL] SELECT, WHERE 문제풀기 (Basic)
Revising the Select Query I Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: select * from city where population > 100000 and countrycode = 'usa' Revising the Select Query II Query the NAME field for all American cities in the CITY table with populations larger than 120000...
2021.01.05