Consider the following tables and assume they have been crea

Consider the following tables and assume they have been created:

Use SQL to manipulate the data and extract the following information (provide SQL query):

Delete the salesperson who sells product Number 16386.

SALESPERON table SPNum 137 186 204 361 issionPecentage 10 15 10 20 CommissionPercentage SPName Baker Adams Dickens Carlyle CUSTOMER table CustNum CustName 0121 0839 0933 1047 1525 1700 1826 2198 2267 Main St. Hardware Janes\'s Stores ABC Home Stores Acme Hardware Store Fred\'s Tool Stores XYZ Stores City Hardware Western Hardware Central Stores SPNum 137 186 137 137 361 361 137 204 186

Solution

Answer:

Below query will full fill the requirement

delete from salesperson sp where sp.spnum = sales.spnum and sales.prodnum = 16386;