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