Question

Using the table EMPLOYEE of CARSHOWROOM database, list the day of birth for all employees whose salary is more than 25000.

Answer 1

SELECT EmpName, DAYNAME(DOB) AS Day_of_Birth
FROM EMPLOYEE
WHERE Salary > 25000;

Explanation:

• DAYNAME(DOB) returns the name of the day (e.g., Monday, Tuesday) from the employee's date of birth.
• WHERE Salary > 25000 filters employees whose salary is greater than 25000.