반응형
For this challenge you need to create a simple SUM statement that will sum all the ages.
people table schema
- id
- name
- age
select table schema
- age_sum (sum of ages)
Solution:
SELECT SUM(age) AS age_sum
FROM people;
Result:
| age_sum |
| 5451 |
반응형
'나는 이렇게 학습한다 > Algorithm & SQL' 카테고리의 다른 글
| SQL Basics: Simple JOIN (0) | 2022.05.23 |
|---|---|
| Beginner Series #2 Clock (0) | 2022.05.22 |
| Returning Strings (0) | 2022.05.20 |
| Even or Odd (0) | 2022.05.19 |
| SQL Basics: Simple DISTINCT (0) | 2022.05.18 |