Database: entrepreneur

CREATE TABLE "entrepreneur" (
"Entrepreneur_ID" int,
"People_ID" int,
"Company" text,
"Money_Requested" real,
"Investor" text,
PRIMARY KEY ("Entrepreneur_ID"),
FOREIGN KEY ("People_ID") REFERENCES "people"("People_ID")
);
CREATE TABLE "people" (
"People_ID" int,
"Name" text,
"Height" real,
"Weight" real,
"Date_of_Birth" text,
PRIMARY KEY ("People_ID")
);

Question: How many entrepreneurs are there?
SQL: SELECT count(*) FROM entrepreneur

Question: Count the number of entrepreneurs.
SQL: SELECT count(*) FROM entrepreneur

Question: List the companies of entrepreneurs in descending order of money requested.
SQL: SELECT Company FROM entrepreneur ORDER BY Money_Requested DESC

Question: What are the companies of entrepreneurs, ordered descending by amount of money requested?
SQL: SELECT Company FROM entrepreneur ORDER BY Money_Requested DESC

Question: List the companies and the investors of entrepreneurs.
SQL: SELECT Company ,  Investor FROM entrepreneur

Question: What are the companies and investors that correspond to each entrepreneur?
SQL: SELECT Company ,  Investor FROM entrepreneur

Question: What is the average money requested by all entrepreneurs?
SQL: SELECT avg(Money_Requested) FROM entrepreneur

Question: Return the average money requested across all entrepreneurs.
SQL: SELECT avg(Money_Requested) FROM entrepreneur

Question: What are the names of people in ascending order of weight?
SQL: SELECT Name FROM People ORDER BY Weight ASC

Question: Return the names of people, ordered by weight ascending.
SQL: SELECT Name FROM People ORDER BY Weight ASC

Question: What are the names of entrepreneurs?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID

Question: Return the names of entrepreneurs.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID

Question: What are the names of entrepreneurs whose investor is not "Rachel Elnaugh"?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor != "Rachel Elnaugh"

Question: Return the names of entrepreneurs do no not have the investor Rachel Elnaugh.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor != "Rachel Elnaugh"

Question: What is the weight of the shortest person?
SQL: SELECT Weight FROM people ORDER BY Height ASC LIMIT 1

Question: Return the weight of the shortest person.
SQL: SELECT Weight FROM people ORDER BY Height ASC LIMIT 1

Question: What is the name of the entrepreneur with the greatest weight?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1

Question: Return the name of the heaviest entrepreneur.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1

Question: What is the total money requested by entrepreneurs with height more than 1.85?
SQL: SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  1.85

Question: Give the total money requested by entrepreneurs who are taller than 1.85.
SQL: SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  1.85

Question: What are the dates of birth of entrepreneurs with investor "Simon Woodroffe" or "Peter Jones"?
SQL: SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor  =  "Simon Woodroffe" OR T1.Investor  =  "Peter Jones"

Question: Return the dates of birth for entrepreneurs who have either the investor Simon Woodroffe or Peter Jones.
SQL: SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor  =  "Simon Woodroffe" OR T1.Investor  =  "Peter Jones"

Question: What are the weights of entrepreneurs in descending order of money requested?
SQL: SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested DESC

Question: Return the weights of entrepreneurs, ordered descending by amount of money requested.
SQL: SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested DESC

Question: What are the investors of entrepreneurs and the corresponding number of entrepreneurs invested by each investor?
SQL: SELECT Investor ,  COUNT(*) FROM entrepreneur GROUP BY Investor

Question: How many entrepreneurs correspond to each investor?
SQL: SELECT Investor ,  COUNT(*) FROM entrepreneur GROUP BY Investor

Question: What is the investor that has invested in the most number of entrepreneurs?
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1

Question: Return the investor who have invested in the greatest number of entrepreneurs.
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1

Question: What are the investors that have invested in at least two entrepreneurs?
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor HAVING COUNT(*)  >=  2

Question: Return the investors who have invested in two or more entrepreneurs.
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor HAVING COUNT(*)  >=  2

Question: List the names of entrepreneurs and their companies in descending order of money requested?
SQL: SELECT T2.Name ,  T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested

Question: What are the names of entrepreneurs and their corresponding investors, ordered descending by the amount of money requested?
SQL: SELECT T2.Name ,  T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested

Question: List the names of people that are not entrepreneurs.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)

Question: What are the names of people who are not entrepreneurs?
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)

Question: Show the investors shared by entrepreneurs that requested more than 140000 and entrepreneurs that requested less than 120000.
SQL: SELECT Investor FROM entrepreneur WHERE Money_Requested  >  140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested  <  120000

Question: What are the investors who have invested in both entrepreneurs who requested more than 140000 and entrepreneurs who requested less than 120000?
SQL: SELECT Investor FROM entrepreneur WHERE Money_Requested  >  140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested  <  120000

Question: How many distinct companies are there?
SQL: SELECT count(DISTINCT Company) FROM entrepreneur

Question: Count the number of different companies.
SQL: SELECT count(DISTINCT Company) FROM entrepreneur

Question: Show the company of the tallest entrepreneur.
SQL: SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Height DESC LIMIT 1

Question: Which company was started by the entrepreneur with the greatest height?
SQL: SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Height DESC LIMIT 1