A sample database with a set of simple query tasks to complete intended to help learn SQL from scratch. Includes database initialisation file (set_up_datbase.sql) and a set of example queries (example ...

Simple conversion from MongoDB-like syntax to SQL WHERE clauses. This implements all but a few of MongoDB's query operators and adds a few that were easy to implement. My target SQL is DocumentDB but ...

Any SQL query can be executed on the returned result set. Finally, there is the FOR JSON clause that enables you to format query results as JSON text. We can start with simple examples. In the ...