PostgreSQL Basic SELECT Statement: Query to calculate an expression

13. Write a query to calculate the expression 171*214+625.

Sample Solution:

Code:

-- Performing arithmetic operation: (171 * 214) + 625
SELECT 171 * 214 + 625 AS Result;

Explanation:

• This SQL code performs an arithmetic operation: multiplies 171 by 214, then adds 625 to the result.
• The result of the operation is labeled as "Result" using the AS keyword in the SELECT statement.
• The result set will contain a single column named "Result" with the calculated value of the arithmetic expression.

Output:

pg_exercises=# SELECT 171*214+625 Result;
 result
--------
  37219
(1 row)

Practice Online

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to get the first three characters of the first name for all the employees in the employees table.
Next: Write a query to get the name, including first name and last name of all the employees from employees table