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.