About this course

This training focuses on using Window Functions within Amperity SQL to perform advanced calculations and rankings. It demonstrates how to write a query that first uses a SUM and a GROUP BY to find the total sales revenue for each customer, and then employs the RANK function to order and assign a rank to customers. By joining the transaction data with customer profiles and setting the order to DESCENDING, the resulting query provides a clear list of top-spending customers with their full names and revenue rankings.

After taking this course, you should be able to write similar queries to summarize data in your tenant.

To read more about building queries on Amperity Docs, click here