SQL Practice Logo

SQLPractice Online

Level 3 - IntermediateQuery-Based Questions

Category Conversion Rate

Return category_id and conversion_rate where conversion_rate = purchases / visits from events table.

Schema Context

events(id, category_id, event_type) -- event_type in ('visit','purchase')