Explore BrainMass

Explore BrainMass

    SQL Query Formation: Lowest Priced Book

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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)

    © BrainMass Inc. brainmass.com December 24, 2021, 5:02 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/sql-query-formation-lowest-priced-book-23231

    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.49

    ADVERTISEMENT