SELECT

Choice questions

assessing knowledge of Logical thinking, Math, MySQL, SQL

Code gaps

assessing knowledge of SQL

Task - Level: Easy

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

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB, SQL

Task - Level: Easy

SQL | Stamps catalogue | CASE statement - Make a select statement, by which you will divide your stamps collection into 3 groups.

Choice questions

assessing knowledge of SQL

Programming task - Level: Easy

Python | DNA Analyzer - Implement a method in Python that generates DNA statistical report.

Choice questions

assessing knowledge of SQL, MySQL

Task - Level: Easy

SQL | Music Store | Count function - Write a query which will use the count function. This task can be solved in both MySQL && HSQLDB