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?
A. SELECT state_cd, COUNT(*)FROM statesORDER BY COUNT(*);
B. SELECT state_cd, COUNT(*)FROM statesGROUP BY state_cdORDER BY state_cd;
C. SELECT region_cd, COUNT(*)FROM statesGROUP BY state_cdORDER BY COUNT(*);
D. SELECT region_cd, COUNT(*)FROM statesGROUP BY region_cdORDER BY COUNT(*);
|
Download Printable PDF. VALID exam to help you PASS. |
 |