Skip to main content
SQL • LESSON 40

Arithmetic Expressions

How can SQL perform calculations while returning data?

Beginner2 Minutes530 XP
🤔 THE QUESTION

How can SQL perform calculations while returning data?

💡 WHAT IS IT?

Arithmetic expressions allow direct numerical transformations such as salary bonuses or currency adjustments per row.

🎯 WHAT IS IT USED FOR?

Applying wage adjustments, tax deductions, price markups, shipping fees directly in queries.

💻 EXAMPLE
SELECT
name,
salary,
salary + 5000 AS adjusted_salary
FROM employees;

🎯 Mission Objectives

Practice typing production-grade SQL code for Arithmetic Expressions.

  • Addition (+)
  • Arithmetic in SELECT
  • Adjusted values
  • Row-level calculations