SQL Query |
---|
WITH z0 AS (SELECT * FROM meme m0 WHERE m0.rid="college" AND m0.bid="columbia" AND m0.qnt!=0), z1 AS (SELECT * FROM meme m0 WHERE m0.rid="occupation" AND m0.bid="lawyer" AND m0.qnt!=0 AND m0.aid IN (SELECT aid FROM z0)) SELECT * FROM z0 WHERE aid IN (SELECT aid FROM z1) UNION ALL SELECT * FROM z1; |
Results | |||
---|---|---|---|
A | R | B | Q |
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 |