Data Analyst SQL Technical Interview Questionnaire
Please complete this form to help us assess your SQL and data analysis skills as part of our interview process.
Full Name
*
First Name
Last Name
Email Address
*
example@example.com
Phone Number
Please enter a valid phone number.
Format: (000) 000-0000.
Years of Experience with SQL
*
Which SQL databases have you worked with?
*
MySQL
PostgreSQL
Microsoft SQL Server
Oracle
SQLite
Other
Rate your proficiency in SQL (from 1 = Beginner to 5 = Expert)
*
Beginner
1
2
3
4
Expert
5
1 is Beginner, 5 is Expert
Select the correct SQL statement to retrieve all columns from the 'employees' table where the department is 'Sales'.
*
SELECT * FROM employees WHERE department = 'Sales';
SELECT department FROM employees WHERE department = 'Sales';
SELECT * WHERE department = 'Sales' FROM employees;
Other (please specify)
Given the following table structure, write an SQL query to find the average salary of employees in each department. Table: employees (id, name, department, salary)
*
Review the following SQL query. Identify any errors and suggest corrections. SELECT name, SUM(salary) FROM employees GROUP BY department;
*
For each of the following data analysis tasks, indicate your confidence level.
*
Rows
Very Confident
Confident
Somewhat Confident
Not Confident
Writing complex JOIN queries
1
2
3
4
Aggregating data with GROUP BY
5
6
7
8
Optimizing slow queries
9
10
11
12
Using window functions
13
14
15
16
Describe a challenging SQL data analysis problem you have solved. What approach did you take?
Submit Application
Should be Empty: