MSSQL

Database task - Level: Medium

SQL | MSSQL | Finding nulls - Write a query that returns the names of all items which are not available

Database task - Level: Medium

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

Database task - Level: Medium

SQL | MSSQL | Using aggregates - Write a query that returns the names of all items of a given category

Database task - Level: Medium

SQL | MSSQL | Finding duplicates - Write a query that returns the names of all items which are duplicated

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB

Task - Level: Medium

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.

Choice questions

assessing knowledge of SQL, MySQL

Task - Level: Medium

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.

Choice questions

assessing knowledge of SQL

Task - Level: Easy

SQL | Books | find books without ratings - Select all title of the books which have no rating.

Choice questions

assessing knowledge of SQL

Task - Level: Hard

MSSQL - Rewards Program - Write a query which will find the top 3 ranked customers according to the revenue they created with all of their orders

SQL task

The candidate will be asked to solve two simple SQL queries related to a database with books and reviews data.