
Mongo D B Query: Line 1: d b dot art dot find open parenthesis. Line 2: Open curly brace. Line 3: title colon forward slash caret The forward slash comma. Line 4: Open double quotes artist dot died close double quotes colon open curly brace dollar symbol l t colon 1800 close curly brace. Line 5: Close curly brace comma. Line 2 to Line 5 is labeled Criteria Line 6: Open curly brace. Line 7: title colon 1 comma. Line 8: year colon 1 comma. Line 9: Open double quotes artist dot last close double quotes colon 1 comma. Line 10: Open double quotes location dot name close double quotes colon 1. Line 11: Close curly brace. Line 6 to Line 11 is labeled Projection Line 12: Close parenthesis dot sort open parenthesis open curly brace year colon 1, title colon 1 close curly brace close parenthesis dot limit open parenthesis 5 close parenthesis. Line 13 is labeled Cursor Modifiers.
S Q L Equivalent: Line 1: SELECT. Line 2: title comma year comma artist dot last. Line 3: location dot name. Line 4: FROM. Line 5: art. Line 6: WHERE. Line 7: title LIKE open double quotes The percent close double quotes. Line 8: AND. Line 9: artist dot died less than 1800. Line 10: ORDER BY. Line 11: year comma title. Line 12: LIMIT 5.
Back