179

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