Question

Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?

A. SELECT name, title, retail
FROM books, publisher
WHERE cost > 35.95;
B. SELECT name, title, retail
FROM books NATURAL JOIN publisher
WEHRE cost > 35.95;
C. SELECT p.name, b.title, b.retail
FROM books b NATURAL JOIN publisher p
WHERE b.cost > 35.95;
D. none of the above

Answer 1

The correct SQL statement to display the publisher name, book title, and retail price of all books that cost more than $35.95 is option C.

Step-by-step explanation:

A SQL statement is a set of instruction that consists of identifiers, parameters, variables, names, data types, and SQL reserved words that compiles successfully. SQL stands for Structured Query Language. SQL commands are the instructions used to communicate with a database to perform tasks, functions, and queries with data.

SQL commands can be used to search the database and to do other functions like creating tables, adding data to tables, modifying data, and dropping tables.The correct SQL statement to display the publisher name, book title, and retail price of all books that cost more than $35.95 is option C: SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost > 35.95;

This statement uses the correct table aliases, joins the 'books' and 'publisher' tables using NATURAL JOIN, specifies the desired columns (publisher name, book title, and retail price), and filters the results to include only books with a cost greater than $35.95. By using table aliases, it becomes easier to read and understand the query. The 'b' alias refers to the 'books' table, and the 'p' alias refers to the 'publisher' table.