PostgreSQL Basic SELECT Statement: Query to calculate an expression

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

Sample Solution:


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


  • 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.


pg_exercises=# SELECT 171*214+625 Result;
(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

What is the difficulty level of this exercise?

Follow us on Facebook and Twitter for latest update.