Structured Query Language Tables to answer

Display the substring of the Address (starting from 5th position to 11 th position) of all

employees.

Display the Mgrstartdate on adding three months to it.

Display the age of all the employees rounded to two digits.

Find the last day and next day of the month in which each manager has joined.

Print a substring from the string Harini.

Replace the string ni from Harini by sh.

Print the length of all the department names.

Print the system date in the format 25 th May 2007.

Display the date after 10 months from current date.

Display the next occurrence of Friday in this month.

How many different departments are there in the employee table

For each department display the minimum and maximum employee salaries

Print the average annual salary.

Count the number of employees over 30 age.

Print the Department name and average salary of each department.

Create a logical table to store employee details who is getting salary more than 10000.

Create a table to store the employees details based on the department no

List the names of all managers who have no dependents.

List the employees names and the department names if they happen to manage a department.