SQL Query Formation: Lowest Priced Book
Not what you're looking for? Search our solutions OR ask your own Custom question.
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)
https://brainmass.com/computer-science/sql/sql-query-formation-lowest-priced-book-23231
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.49