Question

Given the following schema books(id,title,pub_year,pages,isbn), what is the SQL statement needed to find all the books published in the year 2002?

a)SELECT pub_year = 2002 in books;

b) SELECT ALL in books WHERE pub_year = 2002;

C) SELECT * FROM books WHERE (pub_year,2002);

D) SELECT * FROM books WHERE pub_year = 2002;

Answer 1

Answer

Answer:
--------
D) SELECT * FROM books WHERE pub_year = 2002;

Explanation:
------------
SELECT * -> get all the information
FROM books  ->  about books
WHERE pub_year = 2002 -> which are published in 2002