Question

Create a database with the following tables and write queries in MySQL:

SALESMAN{SID, FNAME, LNAME, PRODID, QUAN, AMT}

PRODUCT{PID, PNAME, IN_STOCK}

1. Write an SQL Query to display the first names of the salesperson in the upper case using the alias FIRST_NAME.

2. Write an SQL COMMAND to display the names of the products that are out of stock.

3. Write an SQL Query to display the details of the salesperson whose sale_amount is the second highest.