Table: premier_league_clubs
Columns: club
manager
captain
manufacturer
sponsor

Question: What Premier League Manager has an Adidas sponsor and a Newcastle United club?
SQL: SELECT "manager" FROM premier_league_clubs WHERE "manufacturer" = 'adidas' AND "club" = 'newcastle united'

Question: Which Manchester United captain is sponsored by Nike?
SQL: SELECT "captain" FROM premier_league_clubs WHERE "manufacturer" = 'nike' AND "club" = 'manchester united'

Question: Who is Dean Whitehead's manager?
SQL: SELECT "manager" FROM premier_league_clubs WHERE "captain" = 'dean whitehead'

Question: In which club is Ledley King a captain?
SQL: SELECT "club" FROM premier_league_clubs WHERE "captain" = 'ledley king'

Question: Who is the captain of Middlesbrough?
SQL: SELECT "captain" FROM premier_league_clubs WHERE "club" = 'middlesbrough'