Chapter 8, Problem 3RQ

Which of the following is not a valid SELECT statement? SELECT lastname, firstname FROM customers; SELECT * FROM orders; Select FirstName NAME from CUSTOMERS; SELECT lastname Last Name FROM customers;

Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;

Which of the following is a valid SELECT statement? a. SELECT TITLES TITLE! FROM BOOKS; b. SELECT customer# FROM books; c. SELECT title AS Book Title from books; d. all of the above