Employees With an Invalid Salary

Mediumsql

A CHECK (salary > 0) constraint should exist on employees but doesn't yet, so some rows have a zero or negative salary. Write a query returning id, name, and salary for every employee whose salary is 0 or less, ordered by id.

sql
CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  department TEXT,
  salary INTEGER
);

Sample data:

sql
INSERT INTO employees (id, name, department, salary) VALUES
(1, 'Asha', 'Engineering', 85000),
(2, 'Rohan', NULL, 62000),
(3, 'Neha', 'Sales', -500),
(4, 'Vikram', 'Sales', 71000);

Example 1

Input

(none)

Output

id	name	salary
3	Neha	-500

This is exactly the kind of violation a CHECK (salary > 0) constraint would have prevented from ever being inserted. Reference: SELECT id, name, salary FROM employees WHERE salary <= 0 ORDER BY id;

Input (stdin)

Output

Run your code to see output here...