Daily Dose of DS offers a daily dose of inspiration, education, and motivation for data scientists and aspiring data professionals. Through bite-sized articles, tutorials, and curated resources, readers embark on a journey to master the art and science of data analysis, machine learning, and artificial intelligence. By staying updated with the latest trends, techniques, and tools in data science, readers can hone their skills and stay ahead in this rapidly evolving field.

Daily Dose of Data Science | Avi Chawla | Substack

This post discusses three lesser-known grouping operations in SQL: Grouping Sets, Rollup, and Cube. These operations allow for efficient multiple aggregations on the same table, generating subtotals, grand totals, and all possible combinations of aggregations. The order is important in ROLLUP, and CUBE creates a result set with all possible combinations.

Grouping Sets, Rollup and Cube in SQL