// SQL
SELECT m.* FROM meme m JOIN (SELECT aid FROM meme GROUP BY aid HAVING SUM(CASE WHEN (rid='college' AND bid='harvard') THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN (rid='college' AND bid='columbia') THEN 1 ELSE 0 END) > 0) AS aids ON m.aid = aids.aid;
A.R:B=Q
barack_obama.birth_country:usa=1
barack_obama.birth_state:hawaii=1
barack_obama.birth_year:ad1961=1
barack_obama.child:malia_obama=1
barack_obama.child:sasha_obama=1
barack_obama.college:columbia=1
barack_obama.college:harvard=1
barack_obama.college:occidental=1
barack_obama.election_year:ad2008=1
barack_obama.occupation:illinois_state_senator=1
barack_obama.occupation:lawyer=1
barack_obama.occupation:senator=1
barack_obama.party:democratic=1
barack_obama.pres_order:first=44
barack_obama.spouse:michelle_obama=1
barack_obama.time_served:year=8
Example Queries (Help)
qry.all Show all data in this DB.
george_washington All about George Washington.
.child Who were children of the presidents?
:lawyer Which presidents were lawyers?
.college:harvard Which presidents attended Harvard for college?
.pres_order=10 Who was the tenth president?
.college:columbia .occupation:lawyer Which presidents attended Columbia and were lawyers?
.pres_order>=20 .pres_order<=30 Who were the twentieth through thirtieth presidents?
.pres_order .child=f Which presidents did NOT have children?
.pres_order>=20 .pres_order<=30 .spouse=g Who were the spouses of the twentieth through thirtieth presidents?
.college:harvard .college:columbia qry.all Use qry.all to return all memes related to the matching As.