SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE employee_data( id SERIAL PRIMARY KEY, first_name TEXT NOT NULL, last_name TEXT NOT NULL, salary INT NOT NULL, department VARCHAR(50) NOT NULL, gender CHAR(10), employee_id VARCHAR(50) NOT NULL ); INSERT INTO employee_data (id, first_name, last_name, salary, department, gender, employee_id) VALUES (1, 'Mark', 'Morisson', 2000, 'Tech', 'female', 1), (2, 'Jennifer', 'Michael', 5000, 'Tech', 'female', 3), (3, 'Jemmy', 'Ken', 2500, 'Finance', 'male', 5), (4, 'Ruth', 'Stones', 7000, 'Customer Care', 'female', 6), (5, 'Ernest', 'Luke', 2000, 'Maintenance', 'male', 2), (6, 'Madison', 'George', 2000, 'Maintenance', 'male', 4); CREATE VIEW Vemployee_data AS SELECT id, first_name, last_name, department, gender FROM employee_data; SELECT * FROM Vemployee_data; DROP VIEW IF EXISTS Vemployee_info; CREATE VIEW Vemployee_info AS SELECT id, first_name, department, gender FROM employee_data; SELECT * FROM Vemployee_info WHERE gender = 'female';