search

Jacobvu84 / sql-basic-advance

SQL
0 stars 0 forks source link

UNION count-salary-categories #13

Open Jacobvu84 opened 8 months ago

Jacobvu84 commented 8 months ago

image

# Write your MySQL query statement below
(SELECT "Low Salary" AS category, COUNT(*) AS accounts_count FROM accounts WHERE income < 20000)
UNION
(SELECT "Average Salary" AS category, COUNT(*) AS accounts_count FROM accounts WHERE income BETWEEN 20000 AND 50000)
UNION
(SELECT "High Salary" AS category, COUNT(*) AS accounts_count FROM accounts WHERE income > 50000)