Practice Topics Basic SELECT Statements Overview The SELECT statement is used to identify the fields that you wish to view in the query output. Let’s say that one table has 50 fields. If you want to view 10 of the… Read More »SQL Week 1 Practice Problems
Practice Topics Common Table Expressions (CTEs) Overview In this Week 3 post, you were introduced to subqueries. Subqueries are really ugly when included in a complex query. They are hard to read, especially when other things are going on around… Read More »SQL Week 4 Practice Problems
Practice Topics Advanced Joins Overview In this Week 2 post, you were introduced to a basic join. In that post, an INNER JOIN was used. In this post, you will learn about the difference between INNER JOIN and LEFT JOIN.… Read More »SQL Week 3 Practice Problems
Practice Topics Aggregation with GROUP BY Overview Aggregation is when you collapse a detailed dataset into a summarized one. Picture an Excel file with a pivot table tab summarizing a more detailed data tab. Aggregation is the equivalent of the… Read More »SQL Week 2 Practice Problems