Question

Database, must be typed for Ms Access,

Write a query to display the book number, title, and cost for all books that cost $59.95 sorted by book number?

Answer 1

Thanks for the question.

Assuming the table name is BOOK and the column names are BOOK_NUMBER, TITLE, COST respectively. The the query will be as follows

SELECT BOOK_NUMBER, TITLE, COST
FROM BOOK where cost=59.95 order by book_number;

SELECT <Column 1 Name>,<Column 2 Name>,<Column 3 Name> FROM <Table Name> WHERE <COLUMN NAME> =

<VALUE> ORDER BY <TABLE NAME>

The only condition for filtering the data is cost should be equal to 59.95 which is why we are using COST=59.95 and we need to sort them by BOOK_NUMBER so we are using ORDER BY BOOK_NUMBER