SQL
MIDDLE

Online store stock Test for Middle SQL Developer | MSSQL

Overall seniority level
Middle
Test duration
65 minutes
Evaluation
Automatic
Tested skills:

Test overview

Test is combined from various tasks. SQL tasks. All evaluated automatically.

Task types

SQL task

SQL | MSSQL | Finding duplicates - Write a query that will return the names of all items that have multiple clone entries in the database.

Level: Medium

Tested skills: MSSQL, QA, SQL

SQL task

SQL | MSSQL | Finding date ranges - Write a query that returns the names of all items added within the last 7 days.

Level: Medium

Tested skills: MSSQL, QA, SQL

SQL task

SQL | MSSQL | Using aggregates - Write a query that returns the number of gadgets (not their stock) that are listed under the "Branding" category.

Level: Medium

Tested skills: MSSQL, QA, SQL

SQL task

SQL | MSSQL | Finding nulls - Find all faulty items in the database according to the above observation.

Level: Easy

Tested skills: MSSQL, QA, SQL

Automatic evaluation

We automatically score multi-choice tests and programming tasks and evaluate candidate code for logical correctness, time efficiency and code quality.

DevSkiller logo TalentBoost logo TalentScore logo