반응형
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.
Solution:
SELECT id, name, birthday, LOWER(race) as race FROM demographics;
반응형
'나는 이렇게 학습한다 > Algorithm & SQL' 카테고리의 다른 글
| Expressions Matter (0) | 2022.05.15 |
|---|---|
| SQL Basics: Mod (0) | 2022.05.14 |
| SQL Basics: Simple WHERE and ORDER BY (0) | 2022.05.12 |
| Sum of numbers from 0 to N (0) | 2022.05.11 |
| Round up to the next multiple of 5 (0) | 2022.05.10 |