Online Assessment

PostgreSQL Averages and HAVING for Resource Usage

IBMSoftware Engineer · Online Assessment · Aug 2026

Write a PostgreSQL query to identify customers whose websites have excessively high average resource usage. Table schemas: The customers table contains id (INT, primary key) and email (VARCHAR(255)). The site_metrics table contains customer_id (INT, foreign key), cpu_usage (DECIMAL(5,2)), memory_usage (DECIMAL(5,2)), and disk_usage (DECIMAL(5,2)). Specific requirements: The report must show custo…

Shared by a candidate · reported Aug 2026. Interview formats change; use it as a guide, not a script.