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
Courses: Introduction to SQLAdvanced 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: Average difficulty
Courses: Introduction to SQLAdvanced 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: Average difficulty
Courses: Introduction to SQLAdvanced SQL
Exercise: Create a CTE to show - amazingly easily - events containing the words THIS and THAT, in this order.

Go to exercise ...

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

Go to exercise ...

Category: SQL
Topic: Derived tables and CTEs
Level: Harder than average
Courses: Introduction to SQLAdvanced 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
Courses: Introduction to SQLAdvanced SQL
Exercise: For each combination of the top 3 categories and top 3 countries, count the number of events using CTEs.

Go to exercise ...

Category: SQL
Topic: Derived tables and CTEs
Level: Harder than average
Courses: Introduction to SQLAdvanced 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