We are working on this in, Oracle Database 11g Express Edition, using SQL. Please and thank you very much.

1. Find the number and name of each customer that currently has an order on file for a

Rocking Horse.

2. List the item number, description, and category for each pair of items that are in the same category (For example, one such pair would be item CD33 and part DL51, because the category for both items is TOY.)

3. List the item number and order date for each order placed by the customer named

Johnson's Department Store. (Hint: To enter an apostrophe (single quotation mark) within

a string of characters, type two single quotation marks.)

4. List the order number and order date for each order that contains 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)