Find Monthly Salary of Employee If Annual Salary is Given in SQL?

To Find Monthly Salary of Employee If Annual Salary is Given in SQL, we are doing following step:-

• Here first we have created one employee table.
• In that table there are 5 column id, name, age, address and salary.
• Here first we fetch the employee data.
• we have to divide the annual salary by 12 and make an alias column as Monthly_Salary to view the monthly salary of each employee.

Query table :-    select * from employee;