Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
33. Sales Person (Easy)
On this page

Problem

Table: SalesPerson

+-----------------+---------+
| Column Name     | Type    |
+-----------------+---------+
| sales_id        | int     |
| name            | varchar |
| salary          | int     |
| commission_rate | int     |
| hire_date       | date    |
+-----------------+---------+
sales_id is the primary key (column with unique values) for this table.
Each row of this table indicates the name and the ID of a salesperson alongside their salary, commission rate, and hire date.

Table: Company

+-------------+---------+
| Column Name | Type    |

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page