As per, Chegg rule, here is 4 questions that I need help with to be solved, Thank you We are using Oracle Database 11g Express Edition Using SQL 1 For each order, list the order number, order date, item number, part description, and category for each item that makes up the order 2 Repeat Exercise 1, but this time order the rows by category and then by order number 3 Use a subquery to find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10,000 List each sales rep only once in the results 4 Repeat Exercise 3, but this time do not use a subquery 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)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 25, 2024

As per, Chegg rule, here is 4 questions that I need help with to be solved, Thank you. We are using Oracle Database 11g Express

As per, Chegg rule, here is 4 questions that I need help with to be solved, Thank you.

We are using Oracle Database 11g Express Edition. Using SQL.

1. For each order, list the order number, order date, item number, part description, and

category for each item that makes up the order.

2. Repeat Exercise 1, but this time order the rows by category and then by order number.

3. Use a subquery to find the rep number, last name, and first name of each sales rep who represents

at least one customer with a credit limit of $10,000. List each sales rep only once

in the results

4. Repeat Exercise 3, but this time do not use a subquery.

image text in transcribed

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)