SQLite Exercise: Get monthly salary of each and every employee

Last update on November 13 2023 06:55:09 (UTC/GMT +8 hours)

Solution:

19. Write a query to get monthly salary (round 2 decimal places) of each and every employee?

SQLite Code :

SELECT first_name, last_name, round(salary/12,2) as 'Monthly Salary' 
FROM employees;

Sample table : employees

Sqlite Online Editor