// SQL
SELECT * FROM meme WHERE bid='lawyer';
A.R:B=Q
john_adams.occupation:lawyer=1
thomas_jefferson.occupation:lawyer=1
james_madison.occupation:lawyer=1
james_monroe.occupation:lawyer=1
andrew_jackson.occupation:lawyer=1
martin_van_buren.occupation:lawyer=1
john_tyler.occupation:lawyer=1
james_polk.occupation:lawyer=1
millard_fillmore.occupation:lawyer=1
franklin_pierce.occupation:lawyer=1
james_buchanan.occupation:lawyer=1
abraham_lincoln.occupation:lawyer=1
rutherford_hayes.occupation:lawyer=1
chester_arthur.occupation:lawyer=1
grover_cleveland.occupation:lawyer=1
benjamin_harrison.occupation:lawyer=1
william_mckinley.occupation:lawyer=1
william_taft.occupation:lawyer=1
calvin_coolidge.occupation:lawyer=1
franklin_roosevelt.occupation:lawyer=1
barack_obama.occupation:lawyer=1
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.