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

Domande a scelta

valutare la conoscenza di SQL, MongoDB, NoSQL

Lacune nel codice

valutare la conoscenza di MongoDB

Compito - Livello: Medio

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.

Domande a scelta

valutare la conoscenza di SQL, MySQL

Compito - Livello: Medio

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.

Domande a scelta

valutare la conoscenza di SQL

Compito - Livello: Facile

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

Domande a scelta

valutare la conoscenza di 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

Attività SQL

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