MSSQL

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of Mongo, 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.