Write in SQL query

28. For each employee, display the first name, last name, hire date, number of months he works in the company, and number of years he works in the company.
29. For each employee, display the first name, hire date, and hire date plus one year.
30. For each employee, display the first name, hire date, hire date rounded up to the nearest year, and hire date rounded up to the nearest month.
31.For each employee, display the first name, the day of his hire date, and the year of his hire date.
32.Display the last name in upper case, the salary in format model: ‘9,999.999’, and hire date in format model: ‘DD/MM/YYYY’, for all employees whose last name begins with the letter D or K.

Calculate your paper price
Pages (550 words)
Approximate price: -