Lower case

From SQLZoo
Jump to navigation Jump to search

Lower case

schema:gisq

UPPER CASE is similar.

SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LCase(name) FROM bbc
 WHERE UCase(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects