219k views
0 votes
Write a query to display the book title, cost, and year of publication for every book in the system.

1 Answer

3 votes

Answer:

See Explanation

Step-by-step explanation:

The question seem incomplete as the table name is not given.

To write the query, we'll make use of the following definitions:

Table Name: BOOKS

Columns:

Book Title: BOOK_TITLE

Cost: COST

Year of Publication: YEAR_OF_PUBLICATION

So, the query is as follows:

SELECT BOOK_TITLE, COST, YEAR_OF_PUBLICATION FROM BOOKS

Analyzing the query:

SELECT ---- This means the query is to retrieve certain information

BOOK_TITLE, COST, YEAR_OF_PUBLICATION ---- These are the column names to retrieve information from

FROM BOOKS ----- The table to retrieve information from

User Cris Rockwell
by
5.8k points