Question

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

EMPLOYEE {EMPID, FNAME, LNAME, SALARY, DOJ, DEPARTMENT}

PAY_BONUS {EMP_ID, AMT}

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

• Write an SQL Query to display the unique names of the departments.

• Write an SQL Query to display the details of the employees who will get a bonus.