20461C_Mod4_Lab_E5-Writing Queries That Use Cross Joins

20461C_Mod12_Lab_E2-Writing Queries That Use the CROSS APPLY an OUTER APPLY Operators

20461C_Mod12_Lab_E1-Writing Queries That Use UNION Set Operators and UNION ALL Multi-Set Operators

20461C_Mod11_Lab_E4-Writing Queries That Use Inline TVFs

20461C_Mod11_Lab_E3-Writing Queries That Use CTEs

20461C_Mod11_Lab_E2-Writing a SELECT Statement Against a Derived Table

20461C_Mod11_Lab_E1-Writing Queries That Use Views

20461C_Mod10_Lab_E3-Writing Queries That Use Correlated Subqueries and an EXITS Predicate

20461C_Mod10_Lab_E2-Writing Queries That Use Scalar an Multi-Result Subqueries

20461C_Mod10_Lab_E1-Writing Queries That Use Self-Contained Subqueries

20461C_Mod9_Lab_E4-Writing Queries That Filter Groups with the HAVING Clause

20461C_Mod9_Lab_E3-Writing a SELECT Statement to Retrieve the Number of Customers

20461C_Mod9_Lab_E2-Writing Queries That Use Aggregate Functions