How should I practice High Resource Usage Customers?

Start by reading the full statement, solve the visible examples, then compare the pattern against related Wells Fargo online assessment problems in FastPrep.

Is High Resource Usage Customers associated with Wells Fargo?

FastPrep tags this as a Wells Fargo online assessment coding practice problem when the problem catalog has that company and stage context.

High Resource Usage Customers

Wells Fargo● MediumNEW GRADOA

Problem statement

Identify every customer with at least one site_data log where memory utilization, disk utilization, or CPU utilization is strictly greater than 50%.

For each qualifying customer, calculate averages across all of that customer's logs:

average_memory_usage: average of 100 * memory_used_gb / memory_allocated_gb.
average_disk_storage: average of 100 * disk_used_gb / disk_allocated_gb.
average_cpu_utilization: average of cpu_utilization_percent.

Round every average to two decimal places. Return rows ordered by customer_name ascending, then customer_id ascending.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

customers

Customer identities.

Column	Type	Nullable	Description
customer_idPK	Integer	No	—
customer_name	Text	No	—

site_data

Resource-usage logs for monitored customer sites.

Column	Type	Nullable	Description
log_idPK	Integer	No	—
customer_id	Integer	No	—
memory_used_gb	Decimal	No	—
memory_allocated_gb	Decimal	No	—
disk_used_gb	Decimal	No	—
disk_allocated_gb	Decimal	No	—
cpu_utilization_percent	Decimal	No	—

Foreign key: customer_id → customers(customer_id)

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
customer_name	Text	No	—
average_memory_usage	Decimal	No	—
average_disk_storage	Decimal	No	—
average_cpu_utilization	Decimal	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

customers.customer_id and site_data.log_id are unique primary keys.
Every site_data.customer_id references an existing customer.
memory_allocated_gb and disk_allocated_gb are positive.
Usage and allocation values are nonnegative decimals, and CPU utilization is between 0 and 100.
A customer may have multiple logs; averages include every log after the customer qualifies.