Back to problems

Who Made Quota?

SQL · Oracle · Medium

You work with two tables that track sales performance. deals Column Name Type employee_id integer deal_size integer Every row represents a single deal closed by a salesperson. quota Column Name Type employee_id integer quota integer employee_id is the primary key. Each row stores one salesperson’s annual quota target. As a data analyst on the Oracle Sales Operations team, you need to identify which salespeople hit their annual quota. For every employee, return their ID and a…

Checking your access…