QUESTION: 1. Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5 Chris 34 40000 ID Name City Indust
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
QUESTION: 1. Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5 Chris 34 40000 ID Name City Indust
QUESTION: 1. Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5 Chris 34 40000 ID Name City Industry Type 4 Samsonic pleasant J 6 Panasung oaktown J 7 Samony jackson B 9 Orange Jackson B. 7 Dan 41 52000 8 Ken 57 115000 11 Joe 38 38000 Orders Number order_date cust_id salesperson_id Amount 10 8/2196 4 2 540 20 1/30/99 4 8 1800 30 7/14/95 9 460 40 1/29/98 7 2 2400 50 2/3/98 6 CO 7 600 60 3/2/98 6 7 720 70 5/6/98 9 02 150 7 Given the tables above, find the following: (a) Write the SQL statement that will create the table structure for a table named Orders.