QUESTION 1 Write the SQL command to list all rows and columns in the Orders tabl

Question

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

Explanation / Answer

QUESTION 1

SELECT * FROM ORDERS;

QUESTION 2

SELECT ITEM_NUM,DESCRIPTION FROM ITEM WHERE CATEGORY="GME";

QUESTION 3

SELECT ITEM_NUM,DESCRIPTION,ON_HAND*PRICE AS ON_HAND_VALUE FROM ITEM
WHERE CATEGORY IN("GME","TOY");

QUESTION 4

SELECT CUSTOMER_NUM,CUSTOMER_NAME FROM CUSTOMERS WHERE CUSTOMER_NAME LIKE 'A%';

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.