Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 271 Bytes

Easy-SQL-LowerCase.md

File metadata and controls

14 lines (11 loc) · 271 Bytes

Given a demographics table in the following format:

demographics table schema

  • id
  • name
  • birthday
  • race you need to return the same table where all letters are lowercase in the race column.
/*  SQL  */

SELECT *, LOWER(race) as race FROM demographics