IBM
C2090-610 · Question #73
A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?
The correct answer is D. SELECT region_cd, COUNT(*). See the full explanation below for the reasoning.
Question
A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?
Options
- ASELECT state_cd, COUNT(*)
- BSELECT state_cd, COUNT(*)
- CSELECT region_cd, COUNT(*)
- DSELECT region_cd, COUNT(*)
How the community answered
(52 responses)- A2% (1)
- B10% (5)
- C4% (2)
- D85% (44)
Community Discussion
No community discussion yet for this question.