P

[max-hoffman]

every-cause-of-human-outcomes/main*> CREATE TABLE Products(
                                  ->   ProductID Char(38) PRIMARY KEY, /*UUID*/
                                  ->   Manufacturer TEXT,
                                  ->   ProductSeries TEXT,
                                  ->   ProductName TEXT);
every-cause-of-human-outcomes/main*> explain plan SELECT DISTINCT Manufacturer, ProductSeries FROM Products;
+------------------------------------------------------------------+
| plan                                                             |
+------------------------------------------------------------------+
| Distinct                                                         |
|  └─ Project                                                      |
|      ├─ columns: [products.Manufacturer, products.ProductSeries] |
|      └─ Table                                                    |
|          └─ name: Products                                       |
+------------------------------------------------------------------+
5 rows in set (0.00 sec)

every-cause-of-human-outcomes/main*> explain plan SELECT Manufacturer, ProductSeries FROM Products GROUP BY Manufacturer, ProductSeries;
+------------------------------------------------------------------+
| plan                                                             |
+------------------------------------------------------------------+
| GroupBy                                                          |
|  ├─ SelectedExprs(products.Manufacturer, products.ProductSeries) |
|  ├─ Grouping(products.manufacturer, products.productseries)      |
|  └─ Table                                                        |
|      ├─ name: Products                                           |
|      └─ columns: [manufacturer productseries]                    |
+------------------------------------------------------------------+