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

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