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

선택형 문제

에 대한 지식 평가 SQL, MongoDB, NoSQL

Code gaps

에 대한 지식 평가 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.

선택형 문제

에 대한 지식 평가 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.

선택형 문제

에 대한 지식 평가 SQL

Task - Level: Easy

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

선택형 문제

에 대한 지식 평가 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.