.mode column
.header ON
PRAGMA foreign_keys = ON;

.nullvalue NULL


CREATE TABLE payroll (
  user_id INT,
  name TEXT,
  job TEXT,
  salary INT
);

INSERT INTO payroll
  VALUES
    (123, 'Jack', 'TA', 50000),
    (345, 'Allison', NULL, 60000),
    (567, 'Magda', 'Prof', 90000),
    (789, 'Dan', 'Prof', NULL),
    (432, NULL, 'Prof', NULL);


-- give everyone a 10% raise
SELECT name, salary * 1.1 AS new_salary
FROM payroll;

SELECT Name, salary * 0 AS ne
FROM payroll;

SELECT Name, 0 as NewSalary
FROM payroll;

SELECT *
FROM payroll
WHERE job != 'Prof' OR job = 'Prof';

SELECT *
FROM payroll
WHERE job != 'Prof' OR job = 'Prof' or job IS NULL;