postgres_analytic_functions.sql

CREATE TABLE laptops(
	laptop_id		SERIAL,
	laptop_name		VARCHAR(100),
	laptop_brand	VARCHAR(100),
	relesed_year	INT,
	device_type		VARCHAR(100),
	price			DECIMAL(9,2)
);

INSERT INTO laptops (laptop_name,laptop_brand,relesed_year,device_type,price) VALUES
('Microsoft Surface Laptop 4 15-inch','Microsoft',2017,'Office',130),
('Microsoft Surface Pro 7+','Microsoft',2019,'Office',140),
('Apple MacBook Air (M1, 2020)','Apple',2020,'Business',90),
('Apple MacBook Air MREA2HN/A','Apple',2021,'Business',100),
('Dell XPS 13 9310','Dell',2021,'Office',150),
('Dell XPS 15 9500','Dell',2021,'Gaming',200),
('Dell G5 15 SE 5505','Dell',2020,'Business',75),
('HP Chromebook 11a','HP',2020,'Business',20);