SESSION NAME: Advance Select - 1
QUESTION NAME: Weather Observation - Vowels No End
TABLE DESCRIPTION:
Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.
CODE:
select distinct CITY from STATION where CITY RLIKE '[aeiou]*[^aeiou]$';
2 Comments
SESSION NAME:Advance Select - 2
ReplyDeleteQUESTION NAME: Weather Observation - Longest
TABLE DESCRIPTION
Query the two cities in STATION with the longest, as well as their lengths (i.e.: number of characters in the name).
Input Format
The STATION table is described as follows:
Input Format
The STATION table is described as follows:
Please give thi answer also
SESSION NAME:Advance Select - 2
ReplyDeleteQUESTION NAME: Weather Observation - Shortest Query 4
TABLE DESCRIPTION
Query the two cities in STATION with the shortest names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest choose the one that comes first when ordered alphabetically.
Input Format
The STATION table is described as follows:
Input Format
The STATION table is described as follows:
Please give this question answer also