Purchase Solution

SQL Query Formation: Lowest Priced Book

Not what you're looking for?

Ask 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)

Attachments
Purchase this Solution
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 ...

Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Javscript Basics

Quiz on basics of javascript programming language.

View More Free Quizzes
Related BrainMass Solutions

  • Subquery and Join

    130877 SQL 2005 stored procedures, sub query and join general question. 1. Stored procedures in SQL 2005 can be written in a variety of languages. Why is this important in the development of database systems?

  • SQL Statement for Grades

    Using the two tables from #8, write an SQL statement that uses a SUB QUERY and the IN keyword to return the First Name of the customers who live in the state of MI. 10. Tell why the following SQL statement is incorrect.

  • Methods that can be used to graphically create SQL queries

    This is how the application is described in the Books Online (September 2009) help documentation for SQL Server 2008 Enterprise Edition:, where it is now called Query Builder: "Query Builder Use the Query Builder dialog box to create a query for

  • SQL Statement

    Write 1 SQL query that will prove that no records exist for ConsumerID 45678 or the Consumer is from California or Texas. g. Save your SQL query as SQLQuery1D3 and execute the statement. h. Take a screen shot of your query results.

  • Write SQL queries using BETWEEN, LIKE and UNION

    Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use age to find all people in their 20's.) Write a SQL query that uses UNION of the two tables. Be creative.

  • Monitoring the Performance of SQL Server

    SQL Server 2000 Query Analyzer The SQL Server 2000 Query Analyzer is not only a great tool for developing and debugging Transact-SQL code, it is also a great tool for performance tuning Transact-SQL code.

  • Data Manipulation and Monitoring

    SQL Server 2000 Query Analyzer The SQL Server 2000 Query Analyzer is not only a great tool for developing and debugging Transact-SQL code, it is also a great tool for performance tuning Transact-SQL code.

  • SQL QUERIES

    Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection (use zip codes to restrict data). 5. Write a SQL query that uses UNION of the two tables to produce a third table.

  • SQL Accounting Database

    The solution includes an SQL database containing the fields in the current Chart of Accounts, plus a "balance" field, an SQL query that will display all of the database fields, a test of the database by means of a query by account number and a report

View More Related Solutions