
CREATE TABLE "Manufacturers" (
	"Code" INTEGER, 
	"Name" VARCHAR(255) NOT NULL, 
	"Headquarter" VARCHAR(255) NOT NULL, 
	"Founder" VARCHAR(255) NOT NULL, 
	"Revenue" REAL, 
	PRIMARY KEY ("Code")
)


CREATE TABLE "Products" (
	"Code" INTEGER, 
	"Name" VARCHAR(255) NOT NULL, 
	"Price" DECIMAL NOT NULL, 
	"Manufacturer" INTEGER NOT NULL, 
	PRIMARY KEY ("Code"), 
	FOREIGN KEY("Manufacturer") REFERENCES "Manufacturers" ("Code")
)

CREATE TABLE "Manufacturers" (
	"Code" INTEGER, 
	"Name" VARCHAR(255) NOT NULL, 
	"Headquarter" VARCHAR(255) NOT NULL, 
	"Founder" VARCHAR(255) NOT NULL, 
	"Revenue" REAL, 
	PRIMARY KEY ("Code")
)

/*
2 rows from Manufacturers table:
Code	Name	Headquarter	Founder	Revenue
1	Sony	Tokyo	Andy	120.0
2	Creative Labs	Austin	Owen	100.0
*/


CREATE TABLE "Products" (
	"Code" INTEGER, 
	"Name" VARCHAR(255) NOT NULL, 
	"Price" DECIMAL NOT NULL, 
	"Manufacturer" INTEGER NOT NULL, 
	PRIMARY KEY ("Code"), 
	FOREIGN KEY("Manufacturer") REFERENCES "Manufacturers" ("Code")
)

/*
2 rows from Products table:
Code	Name	Price	Manufacturer
1	Hard drive	240.0000000000	5
2	Memory	120.0000000000	6
*/
Find all information of all the products with a price between $60 and $120.
SELECT * FROM products WHERE price BETWEEN 60 AND 120
[{'Code': 2, 'Name': 'Memory', 'Price': 120, 'Manufacturer': 6}, {'Code': 7, 'Name': 'CD drive', 'Price': 90, 'Manufacturer': 2}, {'Code': 9, 'Name': 'Toner cartridge', 'Price': 66, 'Manufacturer': 3}]