Students: student_id first_name last_name --------------------------------- 1 John Smith 2 John Doe 3 Jane Smith 4 Sally Johnson
Which query will give us the following result?
last_name student_id ----------------------- Smith 1 Doe 2
A)
SELECT last_name, student_id FROM Students WHERE last_name IN ('Smith', 'Doe');
B)
SELECT last_name, student_id FROM Students WHERE first_name = 'John';
C)
SELECT * FROM Students WHERE student_id < 3;
D)
SELECT * FROM Students WHERE last_name IN ('Smith', 'Doe') AND student_id < 3;
What would the results of this query look like?
SELECT * FROM Students WHERE last_name != 'Smith' AND first_name = 'John'
A)
first_name last_name --------------------- John Doe Sally Johnson
B)
first_name last_name --------------------- John Doe
C)
student_id first_name last_name --------------------------------- 1 John Smith 2 John Doe
D)
student_id first_name last_name --------------------------------- 2 John Doe
**Write a query that returns the student id for all students with the last name Smith.