Table: social_network_stats
Columns: site
bebo
facebook
friendster
linkedin
myspace
ning
orkut
plaxo

Question: What myspace has linkedin as the site, with an orkit greater than 3?
SQL: SELECT AVG("myspace") FROM social_network_stats WHERE "site" = 'linkedin' AND "orkut" > 3

Question: How many linkedin have Facebook as the site, with a myspace less than 64?
SQL: SELECT COUNT("linkedin") FROM social_network_stats WHERE "site" = 'facebook' AND "myspace" < 64

Question: What is the highest Ning that has a bebo less than 4, an orkut less than 100, with a plaxo greater than 0?
SQL: SELECT MAX("ning") FROM social_network_stats WHERE "bebo" < 4 AND "orkut" < 100 AND "plaxo" > 0

Question: What is the average plaxo that has a myspace greater than 64, a bebo greater than 3, with 4 as the friendster?
SQL: SELECT AVG("plaxo") FROM social_network_stats WHERE "myspace" > 64 AND "bebo" > 3 AND "friendster" = 4