SQL code copied to buffer
×
Login
Login
Don't have an account?
Sign Up
Register
Register
Already have an account?
Log In
☰
SQLtest.online
Practice
Lessons
Test
RU
PT
FR
€
Support the project
⎆
Choose login method:
ВКонтакте
Google
GitHub
LinkedIn
Email
Login on the site is only required to save your progress. You can continue testing without logging into the site.
Group tasks by:
complexity
category
database
Simple
1.
Get the actors
2.
Get the languages list
3.
Retrieve Actor Names
4.
Retrieve All Departments
5.
Staff names
6.
Product categories
7.
Ordered Languages List
8.
Top 5 Longest Films
9.
Find stuff members by condition
10.
Get the sorted list of films with condition
11.
Find film names by description
12.
Retrieve Actors by Name
13.
Find the average length of a movie
14.
Find foreign employees
15.
Ordered Movie Titles
16.
Find clients starting with the letter "A"
17.
Find clients starting with the letter "A" (2)
18.
Find the minimal and maximal film rental cost
19.
Top 10 Movies by Title
20.
Find long movies
21.
Calculate the area of a circle
22.
Calculate circle perimeter
23.
Find active customers
24.
Movies with the highest replacement cost
25.
Get list of clients
26.
Unique Movie Ratings
27.
Get the restricted films list
28.
Get list of restricted films
29.
Create new address record
30.
Update the postal code
31.
Remove customer records
32.
Addresses Lacking Postal Codes
33.
Addresses with Even Postal Codes
34.
Build shared surnames list
35.
Get airports data
36.
Find long-range aircraft
37.
Identify Palindrome Names
38.
What is SQL?
39.
What is DBMS?
40.
What is RDBMS?
41.
What is a Database?
42.
What is ACID?
43.
What are DQL commands?
44.
What is index in SQL?
45.
SQL Tables joins types
46.
Choose join type
47.
Perform price update
48.
Update replacement cost
49.
Order of execution of logical operators
50.
Difference between UNION and UNION ALL
51.
Display a list of departments
52.
Find employee salary
53.
Employees with high salaries
54.
Employees with Above-Average Salaries
55.
Find customers with even numbers
56.
Find customers by phone prefix
57.
Get unique customers list
58.
How avoid accidental deletion?
59.
How to find common rows in SQL?
60.
What relation types exists in SQL?
61.
Find non-Dollar/Euro countries
62.
What is normalization in SQL?
63.
What is a subquery?
64.
Root categories list
65.
Product List
66.
Filtered list of products
67.
Ten heaviest products
68.
Determine the type of relationship
69.
Sort the penguins
70.
Find light weight penguins
71.
Distribution penguins by islands
72.
Find small penguins
73.
Find small penguins species
74.
Search by pattern
75.
Flipper length to body mass rate
76.
Penguins whose sex is unknown
77.
Penguins with absent data
78.
Heavy penguins
79.
Count the penguins
80.
Penguins and Islands
81.
Medium sized bill Penguins
82.
Penguins distribution
83.
Common penguin species
84.
Delete records
85.
Delete employee records
86.
Rename the table
87.
Penguins stats
88.
Create index
89.
Create unique index
90.
Drop table
91.
Missing Data
92.
Small bill Penguins
93.
Not buyng customers
94.
Penguins species
95.
HAVING without aggregate
96.
Duplicate Emails
97.
Update Job Salaries
98.
Create Penguins Table
99.
Combine Penguin Lists
100.
Unique Penguin List
101.
Filter Little Penguins
102.
Full-Text Index
103.
Fare Conditions Types
104.
Total Bookings Amount
Normal
1.
Find customers full names
2.
Find addresses using sub-query
3.
Find addresses using JOIN
4.
Find duplicate actor names
5.
Most Popular Actor Surname
6.
Find all the actors in the film
7.
Find all films of an actor
8.
Find the distribution of films by category
9.
Find the average length of a movie by category
10.
Find the number of films in which the actor took part
11.
Find actors more popular than HENRY BERRY
12.
Analyze monthly payment
13.
Find the best month
14.
Find the most popular film
15.
Analyze rental data for film
16.
Find the Managed Department
17.
Employees on the Video Database Project
18.
Find all customers with unshipped orders
19.
Sort Movies by Multiple Fields
20.
Get the longest movie
21.
Get films list third page
22.
Find the films never been rented
23.
Find customers who did not return rented discs
24.
Find average daily film rentals
25.
Calculate daily income for the month
26.
Generate dates table
27.
Calculate the number of days off in a month
28.
The average cost of renting a movie by category
29.
Average film rental duration for each customer
30.
Find Long Comedies
31.
Find the distribution of customer activity
32.
Find company stores details
33.
Find clients who rented the film
34.
Find minimum, maximum and average film duration
35.
Find long movie categories
36.
Find the number of employees
37.
Find movie distribution by store
38.
Find highly paid employees
39.
Find employees by hire date
40.
Get list of highly paid employees
41.
Find valuable employees
42.
Find the average client activity time
43.
Find the average revenue
44.
Find the store average revenue
45.
Create a salary rating
46.
Quarterly earnings analysis
47.
Find the countries with the most customers
48.
Find customer details
49.
Find the count of rented disks
50.
Find the number of returns
51.
Find the top spending customers
52.
Films Without Available Inventory
53.
Find languages not represented in films
54.
Find movies that have never been rented
55.
Movies with above-average rental rates
56.
Clients with a high number of rentals
57.
Films with the highest replacement cost
58.
Count the rental delays
59.
Calculate the percentage of delays
60.
Get movie cast lists
61.
Extract address and domain from email
62.
Get a list of actors - namesakes
63.
List Movies with Their Categories
64.
Average Rental Duration
65.
Movie rental prices by category
66.
Get rolling payment amounts
67.
Find the number of films in each category
68.
Analyze customer payments
69.
Find the most diverse clients
70.
Find film distribution
71.
Payments analyze
72.
Get list of tables
73.
Get table columns data
74.
Get list of indexes
75.
Distribution of clients by weekday
76.
Client Rentals by Time of Day
77.
Improve distribution of clients by weekday
78.
Movies without actors records
79.
Movies without cast records
80.
Actors Excluding NC-17 Films
81.
Average rentals count
82.
Find the distribution of clients by country
83.
Find never been delayed films
84.
Most Delayed Movies
85.
Create department table
86.
NC-17 Films about DBA
87.
Films about Dogs or Cats
88.
Clients whose first name is the last name of another client
89.
Update Canadian postal codes
90.
Set postal code
91.
Enter new staff record
92.
Create customer addresses view
93.
Distribution of films by categories in JSON format
94.
Generate a list of movies in JSON format
95.
Category popularity analysis
96.
Build a overal email list
97.
Select clients without the letter "A"
98.
Alter the staff table
99.
Find films in several categories
100.
Airports List
101.
Find Boeing aircraft
102.
Get flights departed from Domodedovo
103.
Get a list of aircraft from Domodedovo
104.
Aircraft usage analysis
105.
Find last names with double letters
106.
Customers with matching name initials
107.
Format Customer Names
108.
Aircraft Lacking Business Class Seats
109.
Get counts of seats by class
110.
Get rows and seats count
111.
Calculate the number of seats on flight
112.
Get a list of airports with direct connections
113.
Get a list of no-show passengers
114.
Get a list of passengers
115.
Find the flight delay
116.
Get flights statistics
117.
Find the fastest flight
118.
Calculate the daily number of flights
119.
Obtain a list of passengers
120.
Get list of tables
121.
Get information about the columns
122.
Airports with one-way departures
123.
Find airports relations
124.
Get the passenger list
125.
Get aircraft seat map
126.
Get a list of planes in the air
127.
What are DDL commands?
128.
What are DML commands?
129.
How is data stored in a relational database?
130.
What is a constraint in SQL?
131.
SQL constraints types
132.
Choose tables join type
133.
Calculate the tax
134.
Get formatted list of films
135.
What is a primary key?
136.
Update customer's address
137.
Adjust the rental cost
138.
Find the tomorrow date
139.
Start and End Dates of Current Month
140.
Find the first and last dates of week
141.
Display a table of airports
142.
Count departing passengers
143.
Number of passengers with total
144.
Display a table of departures
145.
Get a list of airports with more than one direct flight
146.
Get list of tables (PostgreSQL)
147.
A sub-departments list (JOIN)
148.
Get a list of sub-departments
149.
Find Employees by Department
150.
Get list of tables (SQL Server)
151.
Find duplicate phone numbers
152.
What is a covering index?
153.
What is a view in SQL?
154.
Move film between categories
155.
Find a June 2005 hit
156.
Get product category color counts
157.
Find films to share
158.
Jobs Without Specific Requirements
159.
Orders shipped in the following month
160.
Update project information
161.
Top states by population
162.
What is a materialized view?
163.
Reduced salaries
164.
List of categories
165.
List of subcategories
166.
What is a SQL transaction?
167.
What is a correlated subquery?
168.
Create a phonebook
169.
Staff Availability Report
170.
What is "PIVOT" in SQL?
171.
Film distribution by category and store
172.
Find highly paid employees
173.
Find the hypotenuse of a triangle
174.
Find the median booking amount
175.
Find the median film's length
176.
Prepare mailing list
177.
Penguins list
178.
Daily income by source
179.
Index usage
180.
Using a covering index
181.
Island with the minimum penguins mass
182.
The most populated island
183.
Classic movies
184.
Penguins stats table
185.
Managed by Robert Nelson
186.
Tables joining algorithms in SQL
187.
Delete films records
188.
Analyze bill length
189.
Analyze flipper length
190.
What is denormalization in RDB?
191.
Create functional index
192.
Staff information
193.
Customers without orders
194.
Overloaded employees
195.
Rank Penguins by Body Mass
196.
Who ordered red helmet?
197.
Who ordered helmet?
198.
What bought Jon Grande?
199.
The most popular product
200.
Products catalog
201.
Mountain Bikes catalog
202.
Products by category distribution
203.
Large categories
204.
Set Last Service Date
205.
Refurbished machines
206.
Data migration
207.
Penguins with low body weight
208.
Most Frequent Co-Purchase
209.
Most popular products
210.
Average Sales Delay
211.
Distance between cities
212.
Penguins habitat
213.
Extract Geometry as Text
214.
Manhattan's subway stations
215.
Area of the Neighborhood
216.
Area of the Neighborhood
217.
Neighborhood Average Area
218.
Extract Geometry as JSON
219.
New York streets length
220.
Rented Films
221.
What is FULL-TEXT index?
222.
Find Aircraft with All Fare Conditions
223.
Is the index fit for query?
224.
Is the index fit for queries?
225.
Get Bookings by Date
Difficult
1.
Find most active customers
2.
Find sad actors
3.
Find the most diverse actors
4.
Find all films where HENRY BERRY did not participate
5.
Calculate factorial
6.
Find average disk idle time
7.
Find the distribution by categories
8.
Salary Ratio Calculation
9.
Analyze monthly payments (2)
10.
Find movie popularity rating
11.
Find EMILY DEE fans
12.
Clients who are not familiar with EMILY DEE films
13.
Find the least popular movies
14.
Films with Low Rental Time
15.
Find actors duets
16.
Find films that were out of stock
17.
Improve payments analyze
18.
Find all the actors in the film
19.
Analyze weekly rentals
20.
Find repeat rentals
21.
Find the Horror films fans
22.
Movies in One Store
23.
Find movies with no available copies
24.
Staff performance analysis
25.
Generate monthly bill
26.
Gap & Islands problem
27.
Find customers who sow same films
28.
Get the list of destination airports
29.
Get a list of airports without direct connections
30.
Rate airports
31.
Find a list of flight options
32.
Rental history
33.
Find average flight occupancy
34.
Find flight occupancy by fare
35.
Find small airports
36.
FInd the plane coordinates
37.
FInd the planes coordinates
38.
What is a subset of the SQL language?
39.
SQL set operators
40.
Find a 2005 hits
41.
Analysis of the cost of film rental by category
42.
Distribution of flights by days of the week
43.
Subcategories count
44.
Find the median salary
45.
Actual statistics
46.
Actual statistics 2
47.
Cumulative payment analysis
48.
Country Area
49.
Population Distribution (Pivot)
50.
Little Italy Stations
51.
Frequently Purchased Product Pairs
52.
Sales by Category Percentage
Very hard
1.
Disc rental and return statistics
2.
Find clients who have met each other
3.
Product Sales Analysis
Not rated
1.
The Storage Engine
2.
The Release Strategy
3.
The MariaDB Foundation Role
4.
Evolution and Compatibility
5.
Passenger names classification
6.
Monthly Bookings Count
7.
Extract Airport Data as JSON
8.
Remove View from Database
9.
Salary Bucketing
10.
Product Weight Buckets
Task 167:
What is a correlated subquery?
A correlated subquery is a type of subquery that is always nested within another subquery.
A correlated subquery is a subquery that references a column from the outer query.
A correlated subquery is a type of subquery that is executed before the outer query.
A correlated subquery is a synonym for a join.
A correlated subquery is a synonym for a nested subquery.
A correlated subquery is a subquery that is executed independently of the outer query.
Mark all correct answers and click the "Check!" button
Check answers
Next
T-SQL Fundamentals by Itzik Ben-Gan
Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.