SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedDebugging Questionsm1 optimizer cardinality internals

Debug Function-Wrapped Predicate

Fix this query so the composite index can be used: SELECT order_id, amount FROM tenant_orders WHERE UPPER(tenant_key) = 'ACME' AND created_at >= DATE '2026-01-01';

Schema Context

tenant_orders(order_id, tenant_key, created_at, amount), index(tenant_key, created_at)