level2.sql

.headers on
.mode column

-- 1. CREATE a table for Employees
CREATE TABLE employees (
    id INTEGER, 
    name TEXT, 
    role TEXT, 
    salary INTEGER
);

-- 2. INSERT some employees
INSERT INTO employees VALUES (1, 'Alice', 'Manager', 80000);
INSERT INTO employees VALUES (2, 'Bob', 'Developer', 60000);
INSERT INTO employees VALUES (3, 'Charlie', 'Developer', 65000);
INSERT INTO employees VALUES (4, 'Diana', 'Designer', 55000);

-- 3. FILTER: Show me ONLY the Developers
SELECT '--- ONLY DEVELOPERS ---' AS '';
SELECT name, salary FROM employees WHERE role = 'Developer';

-- 4. UPDATE: Give Bob a raise! (Change his salary to 75000)
UPDATE employees SET salary = 75000 WHERE name = 'Bob';

-- 5. DELETE: Fire Charlie (Sorry Charlie!)
DELETE FROM employees WHERE name = 'Charlie';

-- 6. FINAL RESULT: Show everyone who is left
SELECT '--- FINAL COMPANY LIST ---' AS '';
SELECT * FROM employees;