날아보자!

--내가 통과한 코드 SELECT CASE WHEN A+B > C AND B+C > A AND A+C > B THEN CASE WHEN A=B AND B=C AND A=C THEN 'Equilateral' WHEN A!=B AND B!=C AND A!=C THEN 'Scalene' WHEN (A=B AND A!=C) OR (B=C AND B!=A) OR (A=C AND A!=B) THEN 'Isosceles' END ELSE 'Not A Triangle' END FROM TRIANGLES; --훨씬 심플한 코드...; SELECT CASE WHEN A + B > C AND B + C > A AND A + C > B THEN CASE WHEN A = B AND B = C THEN 'Equilateral' ..

Higher Than 75 Marks 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 students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID. Input Format The STUDENTS table is described as follows: The Name column only contains uppercase (..

Weather Observation Station 1 Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. SELECT CITY, STATE FROM STATION; Weather Observation Station 3 Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicate..

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...