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:
WHERE SELECT MIN(PRICE)
(See attachment for details)
The first sequence of queries are for MySQL 4.0 and earlier releases where sub queries are not permitted. Hence we use temporary ...