SQL   Table Transformation: Conditional Aggregates


About the Table Transformation: Conditional Aggregates category (2)
7/8 Why Not SUM(CASE WHEN....) (3)
4/8 count(case when...) (4)
6.combining aggregates show either 0 or 100 (2)
Combining aggregates II question (3)
Using CASE WHEN as a GROUP (3)
4. count(case when) (3)
CASE THEN 1 and THEN distance (3)
Aggregate functions.1/8 (2)
WHEN ____ THEN 1.. what exactly does the 1 represent? (3)
Combining Aggregates II syntax question (4)
7. Combining aggregates II (5)
Using forward slash (2)
Wrong "correct" result for 6. Combining aggregrates (3)
How do brackets affect this code? (4)
SQL table transfromation (2)
Group by 1...? (2)
Combining aggregates and Combining aggregates || (6)
Doubt the the Case exercise (3)
Count(case when) (2)
Count(case when) 'then 1' (2)
Ind the percentage of high elevation airports (elevation >= 2000) by state from the airports table (9)
Stuck on high elevation (6)
Exercise 7/8 - Why my values become NULL (5)
Errors in the high-elevation query (10)
I am stuck on excersise 2/8, I have no idea how to proceed, how do I select the destination ATL? (5)
The difference in () and (()) (2)
I am totally lost in the first lesson (4)
7. Combining aggregates II--- What's wrong with my code (11)
3. case when (3)