IBM
C2090-610 · Question #73
C2090-610 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
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(*)
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.