Ctr

Diverse Skills

You are working for a startup incubator call "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 identify the most promising candidates for success.

The soon-to-be billionaires are in the founders table and their company information is in startups.


founders
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

startups
column_name type
id
INTEGER
name
VARCHAR
mission
VARCHAR

The specialty column in the founders table says what type of skills this person brings to the team. Why Combinator believes that teams with a variety of skills are most promising. We will eliminate any startups where the founders all have the exact same specialty.

Select the IDs of all startups where the founders all have the same specialty.

© 2022 Andrew Carlson. All rights reserved.

startup_id
INTEGER
1
2125
2
3358
3
3460
4
4402
5
4782
6
6412
6 rows

You haven't solved this challenge yet!
Are you sure you want to reveal the answer?