What is a subquery?
Mark all correct answers and click the "Check!" button
SQL code copied to buffer
Group tasks by:
- 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
- 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
- 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
