CE-424-QUIZ#1

SELECT * FROM students

WHERE city <> 'New York'

ORDER BY last_name ASC, first_name DESC;

• 3,8,10,7,9,6,2,4

• 3,6,9,7,8,10,2,4

• 3,6,9,7,10,8,2,4

• None of the choices

SELECT * FROM students WHERE gpa >= 3.5 AND gpa <= 3.7 ORDER BY gpa DESC, last_name ASC;

• 2,6,4

• 6,4,2

• 2,6

• 1,4,6

SELECT * FROM students WHERE city = 'Chicago' OR city = 'Los Angeles' ORDER BY last_name DESC, first_name ASC;

• 9,7,6,3

• 2,9,7,3

• 7,3,6,2

• 7,3,2,8

SELECT * FROM students WHERE city <> 'Los Angeles' AND gpa > 3.7 ORDER BY gpa DESC, age ASC;

• 10,1

• 10,9,1

• 1,10,2

• 10,9,6

SELECT * FROM students WHERE age >= 22 ORDER BY age ASC, gpa DESC, last_name ASC;

• 2,6,4,8,5,10

• 8,5,6,4,7,1

• 6,2,4,8,10,5

• 7,4,5,6,2,10

SELECT * FROM students WHERE (city = 'Chicago' OR city = 'San Francisco') AND gpa >= 3.2 ORDER BY gpa DESC, city ASC;

• 4,2,8,7

• 4,2,7,8

• 5,6,4,3

• 5,6,3,4

SELECT * FROM students WHERE age <= 20 OR gpa < 3.3 ORDER BY last_name DESC, first_name ASC;

• 9,8,5,3

• 7,8,4,5

• 5,6,4,2

• 9,8,7,3

SELECT * FROM students WHERE (first_name <> 'Jessica' AND first_name <> 'Emily') AND (gpa < 3.0 OR gpa > 3.8) ORDER BY gpa DESC, first_name ASC;

• 4,5,7,8

• 3,10,5,1

• 5,4,7,8

• 3,10,5

SELECT * FROM students WHERE age >= 21 AND age <= 23 AND city <> 'New York' ORDER BY city ASC, last_name DESC;

• 6,8,7,2,4

• 2,7,6,4,8

• 2,6,7,4,8

• 8,4,6,2,1

SELECT * FROM students WHERE city NOT IN ('Chicago', 'San Francisco') AND gpa >= 3.2 ORDER BY gpa DESC, last_name ASC, first_name ASC;

• 6,10,1,3

• 3,1,10,6,9

• 3,10,1,6,9

• 10,1,3,6