Microsoft SQL training exercises | Derived tables and CTEs

Showing exercises 1-7 (out of 7)

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

Go to exercise ...

Category: SQL
Topic: Derived tables and CTEs
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a CTE (common table expression) listing all important people, then use this to show which courses they have attended.

Go to exercise ...

Category: SQL
Topic: Derived tables and CTEs
Level: Average difficulty
Course: Advanced SQL
Exercise: Use a CTE - common table expression - to show all actors appearing in films directed by Spielberg.

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Derived tables and CTEs
Level: Harder than average
Course: Advanced SQL
Exercise: Create a CTE comparing website usage statistics for 2 countries, and use this to display a final analysis.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

This page has 0 threads Add post