Memelang SQL Demo

SQL Query
`WITH z0 AS (SELECT * FROM meme m0 WHERE m0.rid="college" AND m0.qnt!=0), z1 AS (SELECT aid FROM z0 WHERE aid NOT IN (SELECT aid FROM meme m0 WHERE m0.rid="college" AND m0.bid="harvard" AND m0.qnt!=0)) SELECT * FROM z0 WHERE aid IN (SELECT aid FROM z1);`

Results
A	R	B	Q
`benjamin_harrison`	`college`	`miami`	`1`
`calvin_coolidge`	`college`	`amherst`	`1`
`chester_arthur`	`college`	`union`	`1`
`donald_trump`	`college`	`university_of_pennsylvania`	`1`
`dwight_eisenhower`	`college`	`west_point`	`1`
`franklin_pierce`	`college`	`bowdoin`	`1`
`george_hw_bush`	`college`	`yale`	`1`
`gerald_ford`	`college`	`university_of_michigan`	`1`
`gerald_ford`	`college`	`yale`	`1`
`grover_cleveland`	`college`	`princeton`	`1`
`herbert_hoover`	`college`	`stanford`	`1`
`james_buchanan`	`college`	`dickinson`	`1`
`james_carter`	`college`	`usa_naval_academy`	`1`
`james_garfield`	`college`	`williams`	`1`
`james_madison`	`college`	`princeton`	`1`
`james_monroe`	`college`	`william_and_mary`	`1`
`james_polk`	`college`	`chapel_hill`	`1`
`john_tyler`	`college`	`william_and_mary`	`1`
`joseph_biden`	`college`	`syracuse`	`1`
`joseph_biden`	`college`	`university_of_delaware`	`1`
`lyndon_johnson`	`college`	`southwest_texas_state_teachers`	`1`
`richard_nixon`	`college`	`duke`	`1`
`richard_nixon`	`college`	`whittier`	`1`
`ronald_reagan`	`college`	`eureka`	`1`
`thomas_jefferson`	`college`	`william_and_mary`	`1`
`ulysses_grant`	`college`	`west_point`	`1`
`warren_harding`	`college`	`ohio_central`	`1`
`william_clinton`	`college`	`georgetown`	`1`
`william_clinton`	`college`	`oxford`	`1`
`william_clinton`	`college`	`yale`	`1`
`william_harrison`	`college`	`hampden_sydney`	`1`
`william_mckinley`	`college`	`allegheny`	`1`
`william_taft`	`college`	`university_of_cincinnati`	`1`
`william_taft`	`college`	`yale`	`1`
`woodrow_wilson`	`college`	`princeton`	`1`
`woodrow_wilson`	`college`	`university_of_virginia`	`1`

Memelang SQL Demo
This is demonstration of translating Memelang to SQL for querying relational databases. See the PHP code in GitHub. A Python version is coming soon. Example queries:

Show all data in this DB.
`qry.all`
All about George Washington.
`george_washington`
Who were children of the presidents?
`.child`
Which presidents were members of the Whig party?
`.party:whig`
Which presidents attended Harvard?
`.college:harvard`
Which presidents were born before 1820?
`.birth.year:ad<1820`
Which presidents attended Columbia and were lawyers?
`.college:columbia .lawyer`
Who were the twentieth through thirtieth presidents?
`.president_order>=20 .president_order<=30`
Which presidents attended a college that was not Harvard?
`.college .college:harvard=f`
Which presidents did not have children?
`.president_order .child=f`
Who were the spouses of the twentieth through thirtieth presidents?
`.president_order>=20 .president_order<=30 .spouse`
Use qry.all to return all memes related to the matching As.
`.college:harvard .college:columbia qry.all`
Get all about James Carter as well as Ronald Reagan.
`james_carter; ronald_reagan`
Which presidents were lawyers that attended Harvard or William and Mary?
`.lawyer .college:harvard=t1 .college:william_and_mary=t1`
What were the professions of the presidents?
`?profession`
Which presidents has children that became presidents?
`.child.president_order`