LENGTH OF CHARACTER, ORDER BY AND LIMIT
SELECT CITY,LENGTH(CITY) FROM STATION ORDER BY CITY ASC LIMIT 1;
SELECT * FROM CUSTOMERS
ORDER BY (CASE ADDRESS
WHEN 'DELHI' THEN 1
WHEN 'BHOPAL' THEN 2
WHEN 'KOTA' THEN 3
WHEN 'AHMADABAD' THEN 4
WHEN 'MP' THEN 5
ELSE 100 END) ASC, ADDRESS DESC; ###ORDERING IN A PARTICULAR ORDER
select * from nobel where winner like 'Sir%' order by yr desc,winner asc