Https://app.dataquest.io/c/46/m/179/joining-data-in-sql/8/challenge-complex-query-with-joins-and-subqueries
|
|
3
|
145
|
May 13, 2022
|
179-8 Almost right, but missing some rows from result
|
|
1
|
88
|
January 25, 2022
|
INNER JOIN - Order of Columns & SQL Debugging
|
|
2
|
119
|
October 15, 2021
|
2. Understanding Inner Joins `c.*`
|
|
5
|
171
|
September 21, 2021
|
I'm confused at this stage -- am I wrong? 179-2 Understanding Inner Joins
|
|
16
|
765
|
February 15, 2021
|
If you don't alias a subquery to be the name of the table being joined, does it cause an error?
|
|
1
|
180
|
July 19, 2021
|
Join Clause: how do you decide which table to put on the left vs right?
|
|
1
|
143
|
July 15, 2021
|
Why is my code wrong? urban_pct problem
|
|
1
|
160
|
June 8, 2021
|
Order of execution of SQL Query in 'complex queries with joins and subqueries'
|
|
3
|
1176
|
February 13, 2021
|
179-8 My code produces 'the value for result doesn't look right' when submitted, even though the result is as expected
|
|
4
|
208
|
February 10, 2021
|
Why is CAST-ing Necessary And Which Elements To Apply It To?
|
|
3
|
258
|
January 31, 2021
|
Commenting out SQL code
|
|
5
|
1058
|
January 30, 2021
|
Step 2 - Selecting Specific Columns When Executing the Join?
|
|
2
|
198
|
January 29, 2021
|
Combining Joins with Subqueries
|
|
3
|
211
|
January 21, 2021
|
Doubt about solution
|
|
3
|
532
|
November 24, 2020
|
Is the table cities missing from the factbook.db?
|
|
5
|
589
|
October 4, 2020
|
How do i select a 2nd population column if it is a duplicate column from the first table
|
|
1
|
175
|
August 3, 2020
|
Joining Data in SQL - 8.Challenge: Complex Query with Joins and Subqueries
|
|
5
|
303
|
July 28, 2020
|
Why must the Select From is from Facts F
|
|
6
|
414
|
July 27, 2020
|
C.names vs cities.name is there a difference?
|
|
3
|
250
|
June 27, 2020
|
Challenge: Complex Query with Joins and Subqueries
|
|
2
|
676
|
May 7, 2020
|
SQL m/179, GROUP BY explaination:
|
|
1
|
236
|
May 5, 2020
|
Joining Data in SQL 179-7: Different queries but the same result
|
|
2
|
197
|
May 4, 2020
|
Ordering in SQL INNER JOIN output
|
|
1
|
277
|
March 31, 2020
|
Not understanding the code in Challenge: Complex Query with Joins and Subqueries
|
|
5
|
451
|
March 5, 2020
|
Why can't i refer to alias for the Subquery
|
|
2
|
533
|
February 23, 2020
|