
CREATE TABLE entrepreneur (
	"Entrepreneur_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Company" TEXT, 
	"Money_Requested" REAL, 
	"Investor" TEXT, 
	PRIMARY KEY ("Entrepreneur_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)


CREATE TABLE people (
	"People_ID" INTEGER, 
	"Name" TEXT, 
	"Height" REAL, 
	"Weight" REAL, 
	"Date_of_Birth" TEXT, 
	PRIMARY KEY ("People_ID")
)

CREATE TABLE entrepreneur (
	"Entrepreneur_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Company" TEXT, 
	"Money_Requested" REAL, 
	"Investor" TEXT, 
	PRIMARY KEY ("Entrepreneur_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

/*
2 rows from entrepreneur table:
Entrepreneur_ID	People_ID	Company	Money_Requested	Investor
1	1	Umbrolly	150000.0	Duncan Bannatyne
2	2	Grails Ltd	120000.0	Doug Richard
*/


CREATE TABLE people (
	"People_ID" INTEGER, 
	"Name" TEXT, 
	"Height" REAL, 
	"Weight" REAL, 
	"Date_of_Birth" TEXT, 
	PRIMARY KEY ("People_ID")
)

/*
2 rows from people table:
People_ID	Name	Height	Weight	Date_of_Birth
1	Francesco Postiglione	1.9	80.0	1972-04-29
2	Leonardo Binchi	1.86	57.0	1975-08-27
*/
What are the companies and investors that correspond to each entrepreneur?
SELECT Company ,  Investor FROM entrepreneur
[{'Company': 'Umbrolly', 'Investor': 'Duncan Bannatyne'}, {'Company': 'Grails Ltd', 'Investor': 'Doug Richard'}, {'Company': 'Le Beanock', 'Investor': 'Rachel Elnaugh'}, {'Company': 'IV Cam', 'Investor': 'Peter Jones'}, {'Company': 'Mycorrhizal Systems', 'Investor': 'Simon Woodroffe'}, {'Company': 'Elizabeth Galton Ltd', 'Investor': 'Duncan Bannatyne'}]