HackerRank

문제 1 Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA 문제2 Query th

Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name)

Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot cont

Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more s

Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each