Q.Using the Employee table (JoinDate column), write SQL queries to

This tests the date function YEAR(), both in the SELECT list and in a WHERE condition.

Both parts use the date function YEAR(date), which pulls the year number out of a date.

(i) To show each employee's joining year, we apply YEAR to the JoinDate column in the SELECT list:

SELECT Name, YEAR(JoinDate) AS JoinYear
FROM Employee;

For example, a JoinDate of '2022-06-01' gives a JoinYear of 2022.

(ii) To keep only the employees who joined in 2022, we put the same function in a WHERE condition:

SELECT Name FROM Employee
WHERE YEAR(JoinDate) = 2022;
``` …

To find how many days each employee has served up to today, DATEDIFF and CURDATE can be combined: `SELECT Name, DATEDIFF …

Do not quote the number returned by YEAR (write = 2022, not = '2022'). Also, a full date literal such as JoinDate = '2022-06-01' would match only t …