Explore BrainMass

Explore BrainMass

    SQL Query Formation: Lowest Priced Book

    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 March 4, 2021, 6:00 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.19

    ADVERTISEMENT