Table: ibm_connections
Columns: name
public
intranet
extranet
personal_sites
team_sites
developer

Question: What is the team sites entry for Microsoft Sharepoint?
SQL: SELECT "team_sites" FROM ibm_connections WHERE "name" = 'microsoft sharepoint'

Question: If the intranet entry is Yes, what is the extranet entry for Microsoft Exchange server?
SQL: SELECT "extranet" FROM ibm_connections WHERE "intranet" = 'yes' AND "name" = 'microsoft exchange server'

Question: What is the team sites entry that has a public entry of No and a developer entry of Yes?
SQL: SELECT "team_sites" FROM ibm_connections WHERE "public" = 'no' AND "developer" = 'yes'

Question: What is the name for the entry that has a public of Yes, a personal sites of No, and a team sites of No?
SQL: SELECT "name" FROM ibm_connections WHERE "public" = 'yes' AND "personal_sites" = 'no' AND "team_sites" = 'no'

Question: What is the name of the entry that has a developer entry of Yes and a personal sites entry of No?
SQL: SELECT "name" FROM ibm_connections WHERE "developer" = 'yes' AND "personal_sites" = 'no'