In part 1 we saw how to define a database schema in Cell and we wrote a few basic queries. Those queries were simple enough to be expressed in SQL, and the datasets they returned were a good fit for the tabular data format that is forced on you by SQL. For more complex queries that’s often not the case. As a first example, let’s say that we need to create a report that shows the quarterly sales of all products in the database, organized by customer and year, and we want the products to be grouped by category. …

Giovanni Z.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store