EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Power Platform exercises ()
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
SQL EXERCISES▼
SQL EXERCISES▼
- Simple Queries (4)
- Setting criteria using WHERE (5)
- Calculations (7)
- Calculations using dates (4)
- Basic joins (8)
- More exotic joins (2)
- Aggregation and grouping (8)
- Views (5)
- Subqueries (5)
- Stored procedures (5)
- Variables (8)
- Parameters and return values (11)
- Testing conditions (1)
- Looping (3)
- Scalar functions (6)
- Transactions (5)
- Creating tables (5)
- Temporary tables and table variables (9)
- Table-valued functions (6)
- Derived tables and CTEs (13)
- Dynamic SQL (4)
- Pivots (2)
- Triggers (2)
- Archived (70)
SQL exercises on DERIVED TABLES AND CTES
This page lists the 13 exercises about Derived tables and CTEs in SQL on our website:
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Relatively easy |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use a CTE to group a query by a CASE expression without including it twice. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Relatively easy |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use a Common Table Expression to write a complex query in two distinct parts. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Relatively easy |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Create an expression in a common table expression, and group by this in a query using the CTE. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Average difficulty |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use linked CTEs to show continents having many countries but few events. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Average difficulty |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Show enemies appearing in chosen episodes, using a Common Table Expression (CTE). |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Average difficulty |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Create a CTE to show - amazingly easily - events containing the words THIS and THAT, in this order. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Average difficulty |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use a basic CTE to hold filtered data before joining onto another table. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Average difficulty |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use a derived table to hold a select statement. Then join another table on. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Harder than average |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use a series of CTEs to show categories for countries for events not containing the letters OWL. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Harder than average |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Create a CTE - common table expression - to display breadcrumbs using recursion. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Harder than average |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | For each combination of the top 3 categories and top 3 countries, count the number of events using CTEs. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Harder than average |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Use common table expressions, subqueries or any other technique to solve a complex query. |
| Software: | SQL |
| Version: | Any version of SQL Server |
| Topic: | Derived tables and CTEs |
| Level: | Harder than average |
| Courses: | Introduction to SQLFast-track SQLAdvanced SQL |
| Exercise: | Cretae two CTEs to hold data before joining them together. |
You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?
This page has 0 threads
Add post