| SQL Query |
|---|
SELECT m0.aid AS aid, CONCAT(m0.rid, ' ', m1.rid) AS rid, CONCAT(m0.bid, ' ', m1.bid) AS bid, CONCAT(m0.qnt, ' ', m1.qnt) AS qnt FROM meme m0 JOIN meme m1 ON m0.bid=m1.aid WHERE m0.qnt!=0 AND m0.rid="child" AND m1.rid="president_order" AND m1.qnt!=0; |
| Results | |||
|---|---|---|---|
| A | R | B | Q |
| john_adams | child | john_quincy_adams | 1 |
| john_quincy_adams | president_order | first | 6 |
| george_hw_bush | child | george_w_bush | 1 |
| george_w_bush | president_order | first | 43 |
| 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 |