micro soft access 2013

2.22 Write an SQL statement to display all of the columns using the SQL asterisk (*) wild- card character.

2:26 Write an SQL statement to display the SKU, SKU_Description, and WarehouseID for products that have a QuantityOnHand greater than 0. Sort the results in descending order by WarehouseID and in ascending order by SKu

2:30 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Use the BETWEEN keyword.

2:31 Write an SQL statement to show a unique SKU and SKU_Description for all prod- ucts having an SKU description starting with ‘Half-Dom

2:36 Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order of TotalItemsOnHand.

2:42 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState of all items not stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the NOT IN keyword

CHAPTER 2 Introduction to Structured Query Language
111
CatalogID SKU
SKU_Description
Department
CatalogPage
DateOnWebSite
20130001
100100
Std. Scuba Tank, Yellow
Water Sports
23
2013-01-01
20130002
100500
Std. Scuba Tank, Light Green
Water Sports
NULL
2013-07-01
20130003
100600
Std. Scuba Tank, Dark Green
Water Sports
NULL
2013-07-01
20130004
101100
Dive Mask, Small Clear
Water Sports
24
2013-01-01
20130005
101200
Dive Mask, Med Clear
Water Sports
24
2013-01-01
20130006
201000
Half-dome Tent
Camping
45
2013-01-01
20130007
202000
Half-dome Tent Vestibule
Camping
47
2013-01-01
20130008
301000
Light Fly Climbing Harness
Climbing
76
2013-01-01
20130009
302000
Locking Carabiner, Oval
Climbing
78
2013-01-01
FIGURE 2-40
Cape Codd Database
CATALOG_SKU_2013
Table Data
If you are using the Microsoft Access 2013 Cape_Codd.accdb database, simply copy it to
an appropriate location in your Documents folder. Otherwise, you will need to use the discus-
sion and instructions necessary for setting up the Cape_Codd database in the DBMS product
you are using
For Microsoft SQL Server 2014, see online Chapter 10A.
For Oracle Database 12c or Oracle Express Edition 11g Release 2, see online
Chapter 10B.