Practice Interview Questions
| Question | Status |
|---|---|
Can you write a SQL query to determine the top employee based on customer votes? We're interested in employees who've received votes when customers leave their 10-digit phone numbers in the "customer_response" field. Remember, we're looking for valid 10-digit phone numbers.
If 2, or more employees have the same number of votes, display all of them.
customer_responses table:
| Column Name | Description |
|---|---|
| response_date | Time the customer response was recorded |
| employee_id | The employee who received the response |
| customer_response | The response left by the customer |
| cust_numbers |
|---|
| 12413 | 15 |
| 3112 | 15 |
Can you write a SQL query to determine the top employee based on customer votes? We're interested in employees who've received votes when customers leave their 10-digit phone numbers in the "customer_response" field. Remember, we're looking for valid 10-digit phone numbers.
If 2, or more employees have the same number of votes, display all of them.
customer_responses table:
| Column Name | Description |
|---|---|
| response_date | Time the customer response was recorded |
| employee_id | The employee who received the response |
| customer_response | The response left by the customer |
| employee_id | cust_numbers |
|---|---|
| 12413 | 15 |
| 3112 | 15 |