Eager Founders
You are working for a startup incubator called "Why Combinator." Startup founders are applying to the incubator program for their ideas to get the finances and resources of Why Combinator. The applications for this cycle have closed. Your task is to help the applying teams ensure they have all the requirements met for evaluation.
The soon-to-be billionaires are in the founders table and their company information is in startups.
| column_name | type | reference |
|---|---|---|
id | INTEGER | NULL |
name | VARCHAR | NULL |
email | VARCHAR | NULL |
specialty | VARCHAR | NULL |
proof_work_elig | BOOL | NULL |
startup_id | INTEGER | startups.id |
| column_name | type |
|---|---|
id | INTEGER |
name | VARCHAR |
mission | VARCHAR |
The proof_work_elig column in the founders table represents whether the applicants have submitted their proof of eligibility to work in the US,
a requirement for acceptance to the incubator.
You want to make sure everyone submits this, and remind teams if any of their members haven't done this yet.
Select the IDs of all startups that have any team members who haven't submitted their proof of eligibility to work in the US.
You might want to consult Postgres' list of aggregate functions to find 1 suitable for this problem. Or you can Google it.
