Topics tagged 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 Q&A sql , 179 , 179-8 , sql-joins-relations	1	71	October 23, 2021
INNER JOIN - Order of Columns & SQL Debugging DQ Courses 179 , 179-2 , sql-joins-relations	2	68	October 15, 2021
2. Understanding Inner Joins `c.*` DQ Courses sql , python , 179 , 179-2 , sql-joins-relations	5	137	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	665	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	94	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	103	July 15, 2021
Was very close to the correct answer but not sure why this query doesn't return anything DQ Courses sql , 179 , 179-6 , sql-joins-relations	1	77	July 15, 2021
Why is my code wrong? urban_pct problem DQ Courses sql , 179 , 179-8 , sql-joins-relations	1	121	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	788	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	173	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	163	January 31, 2021
Commenting out SQL code DQ Courses sql , 179 , 179-4	5	877	January 30, 2021
Step 2 - Selecting Specific Columns When Executing the Join? DQ Courses 179 , 179-2 , sql-joins-relations	2	146	January 29, 2021
Combining Joins with Subqueries Q&A sql , 179 , 179-7 , sql-joins-relations	3	180	January 21, 2021
Doubt about solution DQ Courses 179 , 179-8	3	470	November 24, 2020
Is the table cities missing from the factbook.db? DQ Courses python , 179 , 179-1	5	511	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	152	August 3, 2020
Joining Data in SQL - 8.Challenge: Complex Query with Joins and Subqueries DQ Courses sql , 179 , 179-8	5	257	July 28, 2020
Why must the Select From is from Facts F DQ Courses python , 179 , 179-6	6	362	July 27, 2020
C.names vs cities.name is there a difference? DQ Courses dataquest-platform , 179 , 179-7	3	209	June 27, 2020
Challenge: Complex Query with Joins and Subqueries Q&A sql , 179 , 179-8	2	544	May 7, 2020
SQL m/179, GROUP BY explaination: DQ Courses 179 , 589 , 589-3	1	186	May 5, 2020
Joining Data in SQL 179-7: Different queries but the same result DQ Courses sql , 179 , 179-7	2	166	May 4, 2020
Ordering in SQL INNER JOIN output DQ Courses sql , 179 , 179-7	1	239	March 31, 2020
Not understanding the code in Challenge: Complex Query with Joins and Subqueries DQ Courses python , 179 , 179-8	5	392	March 5, 2020
Why can't i refer to alias for the Subquery DQ Courses python , 179 , 179-7	2	408	February 23, 2020