Share
Explore BrainMass

SQL Query Formation: Lowest Priced Book

Use SQL to compete the following:

What is the lowest book price in the database? For example, this is what the database should look like:

(See attached file)

This database has 34 books with prices starting from 25.50 to 5.99. This is what I have so far but it isn't working:

SELECT TITLE
FROM BOOK
WHERE SELECT MIN(PRICE)
;
(See attachment for details)

Attachments

Solution Preview

The first sequence of queries are for MySQL 4.0 and earlier releases where sub queries are not permitted. Hence we use temporary ...

$2.19