SPARK SQL ::: Utilize a database from Kaggle to perform the following : Aggregat

SPARK SQL ::: Utilize a database from Kaggle to perform the following : Aggregation with grouping, Aggregation with Pivotin, Aggregation with rollups and cubes and Window Functions (Ranking functions and Analytic Functions) Also list the problem that you have faced. Induced the SPARK SQL result and function used (text and screenshot). Also include the dataset used.