EasyBasic SELECT

Select employees with column aliases

The query

SQL

SELECT
  emp_id AS "Employee ID",
  first_name || ' ' || last_name AS full_name,
  salary AS "Monthly Salary"
FROM employees;

Tested against PostgreSQL 16

Note

“Use || for string concatenation in PostgreSQL. Aliases with spaces need double quotes.