DERIVED TABLES AND CTES exercises

This page lists the 19 exercises about Derived tables and CTEs in SQL on our website:

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Relatively easy
Exercise:	Create an expression in a common table expression, and group by this in a query using the CTE.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Relatively easy
Exercise:	Use a Common Table Expression in a SQL query to categorise music albums according to sales certifications.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Relatively easy
Exercise:	Use a Common Table Expression to write a complex query in two distinct parts.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Relatively easy
Exercise:	Use a CTE to group a query by a CASE expression without including it twice.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Relatively easy
Exercise:	Use a derived table subquery in SQL Server to categorise a list of venues by size.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Create a CTE to show - amazingly easily - events containing the words THIS and THAT, in this order.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Show enemies appearing in chosen episodes, using a Common Table Expression (CTE).

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Use a basic CTE to hold filtered data before joining onto another table.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Use a common table expression (CTE) in a SQL query to aggregate information about tracks on albums.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Use a derived table subquery in SQL Server to display details of venues and statistics for concerts.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Use a derived table to hold a select statement. Then join another table on.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Average difficulty
Exercise:	Use linked CTEs to show continents having many countries but few events.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	Create a CTE - common table expression - to display breadcrumbs using recursion.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	Cretae two CTEs to hold data before joining them together.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	For each combination of the top 3 categories and top 3 countries, count the number of events using CTEs.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	Use a series of CTEs to show categories for countries for events not containing the letters OWL.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	Use common table expressions, subqueries or any other technique to solve a complex query.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	Use CTEs in a SQL query to return details of venues and statistics of shows held at them.

Show this exercise

Software:	SQL
Topic:	Derived tables and CTEs
Level:	Harder than average
Exercise:	Use derived table subqueries in SQL Server to merge the results of different grouping queries into a single result set.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post

EXERCISE TOPIC

SQL EXERCISES

SQL EXERCISES

DERIVED TABLES AND CTES exercises

Head office

London

Manchester