QUESTION 1

Write the SQL command to list all rows and columns in the Orders table in the TAL Distributors database. You may have the TAL Distributors database open to help you write the command.

QUESTION 2

Write the SQL command to list the item number and description of each item that is in category GME.

QUESTION 3

Write the SQL command to list the item number, description, and on-hand value (units on hand * unit price) of each item in category GME or TOY. Assign the name ON_HAND_VALUE to the computation.

QUESTION 4

Write the SQL command to find the number and name of each customer whose name begins with the letter "A".

QUESTION 5

Write the SQL command to find the total of the balances for all customers represented by sales rep 15 that have balances that are less than their credit limits. Give the name Total Balance to the total column that you compute.

QUESTION 6

Write the SQL command to list the order number and order date for each order that contains an order line for a Fire Engine.

QUESTION 7

Write the SQL command to find the number and name of each customer that placed an order on 10/13/2015.

ER NUM LAST NAME FIRST NAME ADDRESS STATE POSTAL CODE PHONE Click to Add 2332 South St. Apt 3 Springfield East Harford CT Lowell MA 01101 164A South Bend Rd. 32 Sheep Stop St. 10 Greenfield St. Edinboro Rome 373 Highland Ave. 1282 Ocean Walk Somerville Ocean City MA 02143 8115 116 Cherry Blossom St. Weymouth MA Gernowski Athens 132 South St. Apt 27Manchester NH Fairfield GUIDE . LAST-NAME ' FIRST-NAME .| ADDRESS CTY . STATE " POSTAL-CODE PHONE-NUM HIRE-DATE , Cick toAdd . 81-555-767 03-555-1230 781-555-2323 25 Old Ranch Rd. 7 Moose Head Rd. Sunderland Dummer MA NH 03588 24 Shenandoah Rd. Springfield 12 Heather Rd, Mount Desert MA ME OH60 802-555-3339