How often do you use SQL in your current job?
Asked in the HR Phone Screen stage. The recruiter is checking the candidate's technical skill set. For the practical follow-up, use the supplied employee and SQL activity tables to summarize SQL usage for current employees.
Write a SQL query that counts each current employee's SQL activity records and assigns a frequency category.
employee_name, sql_usage_count, and usage_frequencyemployee_name| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| department | VARCHAR(100) | Employee department |
| is_current | BOOLEAN | Whether the employee currently holds the job |
| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique SQL activity record identifier |
| employee_id | INT | Employee associated with the SQL activity |
| usage_date | DATE | Date of the SQL activity |
| tool_name | VARCHAR(100) | Tool used for the SQL activity |