Synthesizing analytical SQL queries from computation demonstration
Xiangyu Zhou, Rastislav Bodík, Alvin Cheung, Chenglong Wang · 2022
Analytical SQL is widely used in modern database applications and data analysis. However, its partitioning and grouping operators are challenging for novice users. Unfortunately, programming by example, shown effective on standard SQL, are less attractive because examples for analytical queries are more laborious to solve by hand.