Question: Consider the following tables in a relational database. Provide the appropriate statement necessary to answer the queries that follow. Primary keys are underlined.
CUSTOMERS (CUSTNO, CNAME, CADDRESS, BALANCE)
SALESPERSONS (SPNO, SNAME, DATE_EMPLOYED, SALARY)
SALES (INVOICENO, DATE, CUSTNO, SPNO)
ITEMS-SOLD (INVOICENO, ITEMNO, QUANTITY, QUANTDISCOUNT)
(a) List all salesperson numbers, salesperson names, and their salaries.
(b) List the addresses, balances, and invoice numbers of those customers who were sold merchandises in the database
(c) List customer name, invoice number and date for items that were sold by the salesperson "Jane Doe", with sales unit more than 100 units, and quantity discount less than 5%.