#1

CREATE TABLE devices (
	name text NOT NULL,
	model text NOT NULL,
	serial integer NOT NULL UNIQUE
);

INSERT INTO devices (name, model, serial)
VALUES
	(
		'HP ZBook 17 G3 Mobile Workstation',
		'ZBook',
		'SN-2015'
	);

#2

ALTER TABLE devices
RENAME TO equipment;

#3

SELECT
	name,
	model,
	serial
FROM
	equipment;

#4

ALTER TABLE equipment 
ADD COLUMN location text;

albums artists customers employees genres invoice_items invoices media_types playlist_track playlists tracks