Heavy Resource Customers Report

Company: IBM

Difficulty: medium

Problem Statement

Heavy Resource Customers Report A web hosting provider records, for every site it hosts, how much of the machine that site consumed. Each measurement is a percentage of capacity for three resources: CPU, memory and disk. A single customer may host many sites, so a customer has one measurement row per site. Build a report of the customers whose hosting is heavy: those whose **average** consumption of at least one of the three resources is greater than `50`. For each such customer report the average of all three resources, so the provider can see the full picture of that customer's consumption rather than only the resource that triggered the alert. Task Write a query that returns one row per qualifying customer with these columns: - `email` - the e-mail address of the customer. - `average_cpu_usage` - the average of `cpu_usage` over all of that customer's rows. - `average_memory_usage` - the average of `memory_usage` over all of that customer's rows. - `average_disk_usage`