1. Find the number and name of each customer that did not place an order on October 21, 2007.
| customer_num |
customer_name |
| 148 |
Al's Appliance and Sport |
| 356 |
Ferguson's |
| 462 |
Bargains Galore |
| 524 |
Kline's |
| 608 |
Johnson's Department Store |
| 687 |
Lee's Sport and Appliance |
| 725 |
Deerfield's Four Seasons |
| 842 |
All Season |
2. Define a view named PART_ORDER. It consists of the part number, description, price, order ?number, order date, number ordered, and quoted price for all order lines currently on file.
3. Write and execute the command to retrieve the part number, description, order number, and quoted price for all orders in the PART_ORDER view for parts with quoted prices that exceed $100. Order the results by part number.
| part_num |
description |
order_num |
quoted_price |
| BV06 |
Home Gym |
21617 |
794.95 |
| CD52 |
Microwave Oven 21617 |
21617 |
150 |
| DR93 |
Gas Range |
21619 |
495 |
| DR93 |
Gas Range |
21610 |
495 |
| DW11 |
Washer |
21610 |
399.99 |
| KL62 |
Dryer |
21613 |
329.95 |
| KT03 |
Dishwasher |
21614 |
595 |
| KV29 |
Treadmill |
21623 |
1290 |
Attachment:- Script.rar