z_OLD: SQL ORDER BY

Question 1 of 25

1. Question

Which state has the fourth smallest land area?

Question 2 of 25

2. Question

Which state has the fourth smallest land area?

Rhode Island
Delaware
Connecticut
Hawaii
New Jersey

Question 3 of 25

3. Question

Which state has the fourth smallest land area?

Question 4 of 25

4. Question

What SQL did you use for the previous question or would be the “best”?

SELECT * FROM States ORDER BY State
SELECT State, LandArea FROM States ORDER BY LandArea
SELECT * FROM States ORDER BY LandArea
SELECT State FROM States ORDER BY 2010Pop
SELECT State, LandArea FROM States ORDER BY LandArea DESC

Question 5 of 25

5. Question

What is the population of California in 2010?

Question 6 of 25

6. Question

What SQL did you use for the previous question or would be the “best”?

SELECT * FROM States ORDER BY State
SELECT LandArea FROM States ORDER BY LandArea
SELECT * FROM States ORDER BY LandArea
SELECT State FROM States ORDER BY 2010Pop
SELECT State, LandArea FROM States ORDER BY LandArea DESC

Question 7 of 25

7. Question

What is the population of California in 2010?

Question 8 of 25

8. Question

Which State has the most counties?

Question 9 of 25

9. Question

What is the size of Rhode Island? Land Area!

Question 10 of 25

10. Question

Which State has the most counties?

Question 11 of 25

11. Question

What is the size of Rhode Island? Land Area!

Question 12 of 25

12. Question

What SQL did you use to get the result in the previous question?

SELECT * FROM States ORDER BY NoCounties
SELECT * FROM States ORDER BY NoCounties DESC
SELECT State, NoCounties FROM States ORDER BY State
SELECT State, NoCounties FROM States ORDER BY NoCounties DESC
SELECT State, NoCounties FROM States ORDER BY State DESC

Question 13 of 25

13. Question

What SQL did you use to get the result in the previous question?

SELECT * FROM States ORDER BY NoCounties
SELECT * FROM States ORDER BY NoCounties DESC
SELECT State, NoCounties FROM States ORDER BY State
SELECT State, NoCounties FROM States ORDER BY NoCounties DESC
SELECT State, NoCounties FROM States ORDER BY State DESC

Question 14 of 25

14. Question

Which states have 14 counties?

Wyoming
New Jersey
Vermont
Nevade
Massachusetts

Question 15 of 25

15. Question

Which states have 100 or 102 counties?

North Carolina
Illinois
Kansas
Missouri
Kentucky

Question 16 of 25

16. Question

What state was formed third from last?

Question 17 of 25

17. Question

What state was formed third from last?

Question 18 of 25

18. Question

Which state would be first in a sort that looked for the state with the least counties, the highest population and the least electors?

Rhode Island
Connecticut
Delaware
Wyoming
Hawaii

Question 19 of 25

19. Question

Which state would be first in a sort that looked for the state with the least counties, the highest population and the least electors?

Rhode Island
Connecticut
Delaware
Wyoming
Hawaii

Question 20 of 25

20. Question

Which of these states does not have more than 10 million in population?

California
Ohio
Michigan
Pennsylvania
Illinois

Question 21 of 25

21. Question

Which State has has more than 10 million in population and more than 200,000 in land size?

California
Texas
Alaska
New York

Question 22 of 25

22. Question

Which state would be first in a sort that looked for the state with the most counties, the lowest population and the most electors?

Rhode Island
Connecticut
Delaware
Wyoming
Hawaii

Question 23 of 25

23. Question

What SQL would you write to find the state that was founded first?

SELECT State, Statehood FROM States ORDER BY Statehood DESC
SELECT State, Statehood FROM States ORDER BY Statehood

Question 24 of 25

24. Question

What SQL would you write to find the state that was founded first?

SELECT State, Statehood FROM `States` ORDER BY Statehood DESC
SELECT State, Statehood FROM `States` ORDER BY Statehood

Question 25 of 25

25. Question

Let’s find all the smallest states – either in population or land size. Which are either smaller than 600,000 in population in 2010 or smaller than 2,000 square miles?

z_OLD: SQL ORDER BY

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question