Results
| A | R | B | Q |
|---|---|---|---|
| william_and_mary | university | various | 1 |
| princeton | university | various | 1 |
| chapel_hill | university | various | 1 |
| bowdoin | university | various | 1 |
| dickinson | university | various | 1 |
| west_point | university | various | 1 |
| kenyon | university | various | 1 |
| williams | university | various | 1 |
| union | university | various | 1 |
| miami | university | various | 1 |
| allegheny | university | various | 1 |
| yale | university | various | 1 |
| university_of_cincinnati | university | various | 1 |
| university_of_virginia | university | various | 1 |
| ohio_central | university | various | 1 |
| amherst | university | various | 1 |
| stanford | university | various | 1 |
| whittier | university | various | 1 |
| duke | university | various | 1 |
| university_of_michigan | university | various | 1 |
| usa_naval_academy | university | various | 1 |
| eureka | university | various | 1 |
| georgetown | university | various | 1 |
| oxford | university | various | 1 |
| occidental | university | various | 1 |
| columbia | university | various | 1 |
| university_of_pennsylvania | university | various | 1 |
| university_of_delaware | university | various | 1 |
| syracuse | university | various | 1 |
Code
Memelang: .university
SQL: SELECT * FROM meme m0 WHERE m0.rid='university' AND m0.qnt!=0;
Memelang Demo
This is demonstration of translating Memelang to SQL for querying relational databases. See the PHP code in GitHub. A Python implementation is coming soon. Example queries:
Show all data in the database.
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 were born before 1820?
.birth.year:ad<1820
Which presidents attended Columbia and were lawyers?
.college:columbia .lawyer
Who were the spouses of the twentieth through thirtieth presidents?
.president_order>=20 .president_order<=30 .spouse
Which presidents did not have children?
.president_order .child=f
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
What were the professions of George Washington?
george_washington?profession
Which presidents previously worked for New York state?
new_york'?profession
Which presidents has children that became presidents?
.child.president_order