
CREATE TABLE furniture (
	"Furniture_ID" INTEGER, 
	"Name" TEXT, 
	"Num_of_Component" INTEGER, 
	"Market_Rate" REAL, 
	PRIMARY KEY ("Furniture_ID")
)


CREATE TABLE furniture_manufacte (
	"Manufacturer_ID" INTEGER, 
	"Furniture_ID" INTEGER, 
	"Price_in_Dollar" REAL, 
	PRIMARY KEY ("Manufacturer_ID", "Furniture_ID"), 
	FOREIGN KEY("Furniture_ID") REFERENCES furniture ("Furniture_ID"), 
	FOREIGN KEY("Manufacturer_ID") REFERENCES manufacturer ("Manufacturer_ID")
)


CREATE TABLE manufacturer (
	"Manufacturer_ID" INTEGER, 
	"Open_Year" REAL, 
	"Name" TEXT, 
	"Num_of_Factories" INTEGER, 
	"Num_of_Shops" INTEGER, 
	PRIMARY KEY ("Manufacturer_ID")
)

CREATE TABLE furniture (
	"Furniture_ID" INTEGER, 
	"Name" TEXT, 
	"Num_of_Component" INTEGER, 
	"Market_Rate" REAL, 
	PRIMARY KEY ("Furniture_ID")
)

/*
2 rows from furniture table:
Furniture_ID	Name	Num_of_Component	Market_Rate
1	Billiard table	14	52.5
2	Chabudai	4	40.0
*/


CREATE TABLE furniture_manufacte (
	"Manufacturer_ID" INTEGER, 
	"Furniture_ID" INTEGER, 
	"Price_in_Dollar" REAL, 
	PRIMARY KEY ("Manufacturer_ID", "Furniture_ID"), 
	FOREIGN KEY("Furniture_ID") REFERENCES furniture ("Furniture_ID"), 
	FOREIGN KEY("Manufacturer_ID") REFERENCES manufacturer ("Manufacturer_ID")
)

/*
2 rows from furniture_manufacte table:
Manufacturer_ID	Furniture_ID	Price_in_Dollar
1	3	239.0
4	2	450.0
*/


CREATE TABLE manufacturer (
	"Manufacturer_ID" INTEGER, 
	"Open_Year" REAL, 
	"Name" TEXT, 
	"Num_of_Factories" INTEGER, 
	"Num_of_Shops" INTEGER, 
	PRIMARY KEY ("Manufacturer_ID")
)

/*
2 rows from manufacturer table:
Manufacturer_ID	Open_Year	Name	Num_of_Factories	Num_of_Shops
1	1980.0	Chevrolet House	36	8
2	1990.0	IKEA	21	19
*/
Give me the names and prices of furnitures which some companies are manufacturing.
SELECT t1.name ,  t2.price_in_dollar FROM furniture AS t1 JOIN furniture_manufacte AS t2 ON t1.Furniture_ID  =  t2.Furniture_ID
[{'Name': 'Bookcase', 'Price_in_Dollar': 239.0}, {'Name': 'Chabudai', 'Price_in_Dollar': 450.0}, {'Name': 'Dining set', 'Price_in_Dollar': 2124.0}, {'Name': 'Billiard table', 'Price_in_Dollar': 443.0}, {'Name': 'Hatstand', 'Price_in_Dollar': 1234.0}]