Monthly Archives: July 2022

Quiz What is the top channel used by each account to market products? How often was that same channel used? However, we will need to do two aggregations and two subqueries to make this happen. Let’s find the number of times each … Continue reading →

Simple the inner subquery is completely independent from the outer query Correlated the inner subquery is dependent on a clause in the outer query The second concept to consider before writing any code is the dependency of your subquery to … Continue reading →

Inline Subquery creates a table that you could then query again in the FROM statement Expert Tip Note that you should not include an alias when you write a subquery in a conditional statement. This is because the subquery is treated as … Continue reading →

The first concept that helps when thinking about the format of a subquery is the placement of it: with, nested, inline, or scalar. The second concept to consider is an indentation, which helps heighten readability for your future self or … Continue reading →

Nested query within another query embedded within the WHERE clause when a user wants to filter an output using a condition met from another table advantageous for readability Use Case for a Nested Subquery When a user wants to filter an … Continue reading →

SQL Subqueries & Temporary Tables Subquery a query within a query a query has both SELECT and FROM clauses to signify what you want to extract from a table and what table you’d like to pull data from. A query that includes subquery, as … Continue reading →

SQL GROUP BY allows creating segments that will aggregate independent from one another allows to take the sum of data limited to each account rather than across the entire dataset goes in between the WHERE and ORDER clause you should … Continue reading →