Purchase Solution

SQL Commands

Not what you're looking for?

Ask Custom Question

I'm not grasping the full concept of these problems, I've completed most successfully. I've tried to get them, but I am have a hard time reworking these.

(This is the table referenced for the following questions)

INVENTORY (SKU, Description, QuantityOnHand, QuantityOnOrder, Warehouse)

1. Write a SQL statement to display the SKU and Description of all items stored in the Seattle, Chicago or New Jersey warhouse. Do not use IN.

2. Write a SQL statement to show SKU and Description for all products having a description starting with 'Half-Dome'.

3. Write a SQL expression to display the Warehouse and a count of QuantityOnHand, grouped by Warehouse. Name the count TotalItemsOnHand.

4. Write a SQL expression to display the Warehouse and a count of QuantityOnHand, grouped by Warehouse. Omit all items that have a count greater than 2. Name the count TotalItemsOnHand and display the reslults in descending order of TotalItemsOnHand.

The following table is for the next set of questions.

INVENTORY (SKU, Description, QuantityOnHand, QuantityOnOrder, Warehouse)

WAREHOUSE (Warehouse, Manager, SquareFeet)

5. Write a SQL statement to show the SKU ande Description of all items stored in a warehouse managed by 'Smith'. Use a subquery.

6. Write a SQL statement to show the Warehouse and average QuantityOnHand of all items stored in a warehouse managed by 'Smith'. Use subquery.

7. Write a SQL statement to show Warehouse, Manager, and QuantityOnHand of all items stored in a warehouse managed by 'Smith'. Use a join.

Purchase this Solution
Solution Summary

This solution basically solves the SQL queries based on the Inventory table. It gives the SQL DML queries in order to solve the questions.

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

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.

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.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • SQL

    They all extended SQL commands by adding more and more commands,functions.But above all SQL is database inspecific and can be implemented any kind of database.Nobody can think of database with out supporting SQL. SQL's user benefits are emphasized.

  • This post addresses access database and queries.

    Have you ever read the SQL commands generated by a Query in Access database? Yes - the SQL commands are basically in-line with the table created in Access through a query.

  • Structured Query Language (SQL) Preliminaries

    Name and describe the SQL statements used for data modification. INSERT, DELETE, and UPDATE commands, which are used to add, remove, and change data values respectively. 3. Compare the join and the SQL subquery.

  • Kudler Fine Foods- Complete Database SQL Queries

    256954 This question deals with a set of SQL queries based on the Kudler Fine Foods Virtual Case. This includes a set of SQL DDL commands as well as DML commands.

  • SQL Characteristics, History, and Example

    There are normally two different ways of using SQL commands, one is to use it in an interpreter and the other is to use it in a host language like C or Java.

  • Microsoft SQL Server

    23230 SQL Commands Use SQL to complete the following: For each type of book, list the type and the average price. There are several BOOKs in each type. See attachement file for details.

  • Please answer and elaborate on the following

    The purpose of this layer is to translate the application's data queries into commands that the DBMS understands.

  • SQL and Differences in Implementation

    There are normally two different ways of using SQL commands, one is to use it in an interpreter and the other is to use it in a host language like C or Java.

  • PHP and MySQL Benefits of relational databases

    They all extended SQL commands by adding more and more commands,functions.But above all SQL is database inspecific and can be implemented any kind of database.Nobody can think of database with out supporting SQL What is redundant data and why should

  • SQL Command

    Commands are emphasized.

View More Related Solutions