Database problems Can someone help me solve these please? These are supposed to

Question

Database problems

Can someone help me solve these please?

These are supposed to be solved with Clearwater Traders database.

This is the database http://imgur.com/a/4Efbn

1 . Determine the inventory price of inventory item (INV_ID) #1

2 . Determine which customers were born in the 1970s

3 . Determine how many shipments have not yet been received

4. Calculate the total quantity on hand for each inventory item in the INVENTORY table - ignore their different sizes and colors

5. Determine how many orders placed on May 31, 2006

6. Create a list of all Florida and Georgia customers

7. Determine how many inventory items have an inventory price greater than $60.00 and are available in a size of L or XL

8. Determine the current age of each customer. Display the customer’s first and last names and their age in years

9. Identify which items in stock (that is INV_QOH >0) are available in sizes Medium or Large and are available in the colors Royal, Bright Pink, or Spruce

10. Determine how many items are not in categories 2 or 4

Explanation / Answer

Select * from Inventory where inv_id=1
Select * from customers where extract(year from c_dob) =1970
Select count(*) from shipment_line where sl_date_received is null
Select item_id, sum(inv_qoh) from Inventory group by item_id
Select count(*) from orders where odate='31-MAY-06'
Select * from customers where c_state in ('FL', 'GA')
Select * from Inventory where inv_price>60 and inv_size in ('L', 'XL')
Select c_first, c_last, (sysdate-c_dob) as age from customers
Select * from Inventory where inv_qoh>0 and inv_size in ('M', 'L') and color in ('Royal', 'Bright Pink', 'Spruce')
Select count (*) from item where cat_id not in (2,4)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

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