Working with, Oracle Database 11g Express Edition, using SQL. I hope you can hel

Question

Working with, Oracle Database 11g Express Edition, using SQL.
I hope you can help me out, Please and Thank you.

1. List the order number and order date for each order that contains an order line for a Fire Engine

2. List the order number and order date for each order that either was placed by Almondton General Store or that contains an order line for a Fire Engine

3. List the order number and order date for each order that was placed by Almondton General Store and that contains an order line for a Fire Engine

4. List the order number and order date for each order that was placed by Almondton General Store but that does not contain an order line for a Fire Engine

51623 FH24 51623 KD34 51625 MTO3 ITEM ITEM NUM DESCRIPTION ON HAND CATEGORY STORE HOUSE PRICE Patience 9 GME $22.99 Skittles BR23 $29.99 1 CD33 Wood Block Set (48 piece) 36 TOY Classic Railway Set DL51 12 TOY $107.95 s3195 DR67 Giant Star Brain Teaser 24 PZL DW23 Mancala. 40 GME 3 sso 00 FDI Rocking Horse 8 TOY $124.95 L1 3895 FI124 65 PZL Puzzle Gift Set KA12 Cribbage Set 60 PZL Pentomino es Brain Teaser $14.95 110 GME K178 $10.95 Pick Up Sticks MT03 45 PZL Zauber kasten Brain Teaser $119.75 NLA% Wood Block set (62 piece) 32 TOY 75 GME TW3S 30 TOY FIGURE 1-2 Sample data for TAL Distributors (continued)

Explanation / Answer

1.

select ord.order_num,ord.order_date
from orders ord
join order_line ln
on ord.order_num = ln.order_num
join item itm
on ln.item_num = itm.item_num
where itm.description = 'Fire Engine'

2.

select ord.order_num,ord.order_date
from orders ord
join order_line ln
on ord.order_num = ln.order_num
join item itm
on ln.item_num = itm.item_num
join customer cust
on ord.customer_num = cust.customer_num
where cust.customer_name = 'Almondton General Store'
or itm.description = 'Fire Engine'

3.

select ord.order_num,ord.order_date
from orders ord
join order_line ln
on ord.order_num = ln.order_num
join item itm
on ln.item_num = itm.item_num
join customer cust
on ord.customer_num = cust.customer_num
where cust.customer_name = 'Almondton General Store'
and itm.description = 'Fire Engine'

4.

select ord.order_num,ord.order_date
from orders ord
join order_line ln
on ord.order_num = ln.order_num
join item itm
on ln.item_num = itm.item_num
join customer cust
on ord.customer_num = cust.customer_num
where cust.customer_name = 'Almondton General Store'
and itm.description not in ('Fire Engine')

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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