Calculated Columns

How can we calculate a new value directly inside a SQL query?

Beginner⏱ 2 Minutes⭐ 520 XP

🤔 THE QUESTION

How can we calculate a new value directly inside a SQL query?

💡 WHAT IS IT?

Mathematical operators (+, -, *, /) can be evaluated on column values to generate dynamic calculated fields.

🎯 WHAT IS IT USED FOR?

Annualizing monthly salaries, computing totals, unit conversions, derived metric calculations.

💻 EXAMPLE

SELECT
name,
salary,
salary * 12 AS annual_salary
FROM employees;

Practice typing production-grade SQL code for Calculated Columns.