Google Cloud: Underutilized Virtual Machines

Unsolved

Google Cloud Cost Management monitors compute engine telemetry to identify idle VMs that are candidates for downsizing or termination. Write a SQL query to find all compute instances with `status = 'RUNNING'` that have an average `cpu_utilization_pct < 5.0` AND `memory_utilization_pct < 10.0`. Output the `instance_id`, `instance_name`, `zone`, `cpu_utilization_pct`, and `memory_utilization_pct`. Order the results by `cpu_utilization_pct` in ascending order (most idle first), resolving ties by `instance_id` ascending.

Learn the concept: WHERE, ORDER BY & LIMIT

SQL Query Editor (Ctrl+Enter to run)

0 characters · Valid

Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments

Asked By:

🏢 Google

Submission History

Your recent query executions and answer checks

Execution Pipeline:

FROM vm_instances

Full source dataset

6 rows total

This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.

Google Cloud: Underutilized Virtual Machines

Official Solution is Hidden

Approach & Explanation

Community Q&A & Discussion

Submission History