JUNIOR

AVG Function Test for Junior SQL Developer | MySQL

Overall seniority level: Junior
Test duration: 25 minutes
Evaluation: Automatic
Tested skills:: SQL HSQLDB MySQL Logical thinking Math Soft Skills SELECT Date Operations

Test overview

Test is combined from various tasks. SQL task, Choice questions and Code gaps. All evaluated automatically.

Task types

Code gaps

SQL | In operator code gap assessing knowledge of SQL

Level: Easy

Tested skills: SQL

Code gaps

SQL | Update operator code gap assessing knowledge of SQL

Level: Easy

Tested skills: SQL

SQL task

SQL | MySQL | Stamps catalogue | AVG Function - Select the stamps (name and price) with price greater than or equal to the total average price.

Level: Easy

Tested skills: HSQLDB, MySQL, SQL

Code gaps

SQL | Union all operator code gap assessing knowledge of SQL

Level: Easy

Tested skills: SQL

Choice questions

7 choice questions assessing knowledge of Date Operations, Logical thinking, Math, MySQL, SELECT, Soft Skills, SQL

Level: Easy

Tested skills: Date Operations, Logical thinking, Math, MySQL, SELECT, Soft Skills, SQL

Automatic evaluation

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