CREATE TABLE IF NOT EXISTS positions ( id integer PRIMARY KEY, title text NOT NULL, min_salary numeric );
INSERT INTO positions (title, min_salary) VALUES ('DBA', 120000), ('Developer', 100000), ('Architect', 150000);
SELECT id,title,min_salary FROM positions;
CREATE UNIQUE INDEX idx_positions_title ON positions (title);
REPLACE INTO positions (title, min_salary) VALUES ('Full Stack Developer', 140000);
SELECT id,title,min_salary FROM positions;
REPLACE INTO positions (title, min_salary) VALUES ('DBA', 170000);
REPLACE INTO positions (id, min_salary) VALUES (2, 110000);
SELECT * FROM albums;
SELECT * FROM artists;
SELECT * FROM customers;
SELECT * FROM employees;
SELECT * FROM genres;
SELECT * FROM invoice_items;
SELECT * FROM invoices;
SELECT * FROM media_types;
SELECT * FROM playlist_track;
SELECT * FROM playlists;
SELECT * FROM tracks;