Arithmetic Expressions

You can compute new values directly in the SELECT list — +, -, *, / all work on numeric columns just like a calculator.

Source data — Pattern 1: Basic Data Retrieval

All queries run against the shared employees table (see schema.sql).

Arithmetic Expressions — source table 1

What it does

You can compute new values directly in the SELECT list — +, -, *, / all work on numeric columns just like a calculator. The result is a new, unnamed column unless you alias it (see topic 4).

Problem

Display salary after adding a ₹5,000 bonus.

SELECT first_name,
       salary,
       salary + 5000 AS salary_with_bonus
FROM employees;

Result

Arithmetic Expressions — result 1

SQL · Pattern 1 — Basic Data Retrieval