Which of the following SQL statements is valid?

a. SELECT books.title, orderitems.quantity

FROM books b, orderitems o

WHERE b.isbn = o.ibsn;

b. SELECT title, quantity

FROM books b JOIN orderitems o;

c. SELECT books.title, orderitems.quantity

FROM books JOIN orderitems

ON books.isbn = orderitems.isbn;

d. None of the above