Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

FrontChaptersSchemaColophon
Chapters · Basic SELECT · Query 020 / 136
EasyBasic SELECT

Show employee salaries with a 10% bonus calculation

The query

SQL
SELECT
  first_name,
  last_name,
  salary,
  ROUND(salary * 0.10, 2) AS bonus,
  ROUND(salary * 1.10, 2) AS total_compensation
FROM employees;
Tested against PostgreSQL 16

Note

“Arithmetic expressions can be used directly in SELECT.

Tables referenced

  • employees10 cols

← Previous

Get 2nd page of employees (OFFSET pagination)

Next →

Select employees using CASE to label salary brackets

The Query & the Schema

Set in Fraunces and Inter Tight. Printed on parchment, in oxblood and ink. No tracking, no accounts, no JavaScript on the answer pages beyond what your browser needs to copy a query.

Compiled for Postgres 16 · MMXXVI