Posts

Showing posts from July, 2022

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.

 Select Name from students  where Marks > 75  order by Right(Name,3), Right(Name,2), Right(Name,1), ID
Post a Comment
Read more

Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

 Select distinct city from station where city not like '[aeiouAEIOU]%' and city not like '%[aeiouAEIOU]'
Post a Comment
Read more