Calculate Monthly Salary
Return each employee’s annual salary and calculated monthly salary.
- Numeric functions
Exercise brief
Understand the request
Compensation systems analyst A monthly payroll preview needs annual salary converted to a comparable monthly amount without losing cents.
Convert each employee’s annual salary into a monthly amount and label the calculated column monthly_salary.
Return
- Return first_name, salary, and monthly_salary in this exact left-to-right order.
- Calculate monthly_salary as salary divided by 12 and round it to 2 decimal places.
Constraints
- Keep one row per employee.
- Use decimal division so salaries that are not divisible by 12 retain cents.
Data you will use
Review the relevant tables before deciding how to join, filter, or aggregate them.
employees
first_nameVARCHAR(50)salaryINTEGER
Hints, when you need them
Open one clue at a time so you still do the reasoning.
Hint 1
Monthly pay is the annual salary distributed across 12 months.
Hint 2
Use decimal division rather than integer division, then apply rounding to the calculated value.
Hint 3
Project the two source columns first, followed by one named arithmetic expression.
Verified SQL answer
Attempt the problem first, then compare structure and reasoning—not just syntax.
Reveal solution and explanation
SELECT first_name, salary, ROUND(salary / 12.0, 2) AS monthly_salary FROM employees;Why this works
Using 12.0 makes the division decimal across the supported engines, while ROUND(..., 2) gives the export a stable currency precision. The calculation combines values with compatible compensation semantics.
Success check
Every employee appears once and monthly_salary equals annual salary divided by 12, rounded to 2 decimal places.
Expected result
Use this output to verify values, aliases, ordering, and row count.
| first_name | salary | monthly_salary |
|---|---|---|
| John | 120000 | 10000 |
| Alice | 85000 | 7083.33 |
| Bob | 80000 | 6666.67 |
| Carol | 60000 | 5000 |
| David | 70000 | 5833.33 |
| Emma | 95000 | 7916.67 |
| Frank | 65000 | 5416.67 |
| Grace | 90000 | 7500 |
| Henry | 55000 | 4583.33 |
| Ivy | 68000 | 5666.67 |
Learn the concepts behind this answer
Strengthen your understanding with these targeted learning topics:
Continue practicing
Build the next SQL skill
WHERE Clause & Filtering
Practice SQL WHERE clauses with realistic boundary, NULL, text, date, exclusion, and production-filtering problems.
Basic SQL Functions
Practice production-oriented string cleanup, numeric transformations, NULL handling, tolerant conversion, and delimiter parsing.
ORDER BY & Sorting
Practice deterministic SQL ordering with tie-breakers, custom priorities, NULL placement, expressions, joined data, aggregates, and portable top-N patterns.
Open the interactive workspace and practice across SQL topics.