Required: Consider the following tables in a relational database. Provide the appropriate "SELECT" SQL statement necessary to answer the queries that follow. Primary keys are underlined and foreign key fields have an asterisk at the end of the field.
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.