QUESTION: Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 ID Name City Industry Type 4 Samsgnis p
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
QUESTION: Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 ID Name City Industry Type 4 Samsgnis p
QUESTION: Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 ID Name City Industry Type 4 Samsgnis pleasant 6 Panasung gaktown J 7 Samony iackson B 9 Orange Jackson B. 5 Chris 34 40000 7 Dan 41 52000 8. Ken 57 115000 11Joe 38 38000 Orders Number order date cust_id salesperson_id Amount 10 8/2/96 4 2 540 20 1/30/99 4 8 1800 30 7/14/95 9 9 1 460 40 1729/98 7 2 2400 50 2/3/98 6 7 600 60 3/2/98 6 7 720 70 5/6/98 9 150 Given the tables above, find the following: (a) Write the SQL statement to insert the new record into customer table.