About this course

This training focuses on writing powerful SQL queries in Amperity by combining two essential functions: Grouping and Joining. The first part shows how to use the GROUP BY clause and an aggregate function (like AVG) to calculate a single metric, such as the average revenue for each Amperity ID. The second part builds on this foundation, demonstrating how to use a LEFT JOIN to connect the transaction data with the separate customer profile table, allowing the final output to include personal details like a customer's full name and email alongside their calculated average revenue.