Topics tagged 179

Topic	Replies	Views	Activity
2. Understanding Inner Joins `c.*` DQ Courses sql , python , 179 , 179-2 , sql-joins-relations	3	20	September 17, 2021
I'm confused at this stage -- am I wrong? 179-2 Understanding Inner Joins DQ Courses dataquest-platform , 179 , 179-2	16	550	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	48	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	64	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	42	July 15, 2021
Why is my code wrong? urban_pct problem DQ Courses sql , 179 , 179-8 , sql-joins-relations	1	80	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	531	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	137	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	110	January 31, 2021
Commenting out SQL code DQ Courses sql , 179 , 179-4	5	610	January 30, 2021
Step 2 - Selecting Specific Columns When Executing the Join? DQ Courses 179 , 179-2 , sql-joins-relations	2	81	January 29, 2021
Combining Joins with Subqueries Q&A sql , 179 , 179-7 , sql-joins-relations	3	129	January 21, 2021
Doubt about solution DQ Courses 179 , 179-8	3	392	November 24, 2020
Is the table cities missing from the factbook.db? DQ Courses python , 179 , 179-1	5	365	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	126	August 3, 2020
Joining Data in SQL - 8.Challenge: Complex Query with Joins and Subqueries DQ Courses sql , 179 , 179-8	5	208	July 28, 2020
Why must the Select From is from Facts F DQ Courses python , 179 , 179-6	6	286	July 27, 2020
C.names vs cities.name is there a difference? DQ Courses dataquest-platform , 179 , 179-7	3	165	June 27, 2020
Challenge: Complex Query with Joins and Subqueries Q&A sql , 179 , 179-8	2	425	May 7, 2020
SQL m/179, GROUP BY explaination: DQ Courses 179 , 589 , 589-3	1	151	May 5, 2020
Joining Data in SQL 179-7: Different queries but the same result DQ Courses sql , 179 , 179-7	2	138	May 4, 2020
Ordering in SQL INNER JOIN output DQ Courses sql , 179 , 179-7	1	195	March 31, 2020
Not understanding the code in Challenge: Complex Query with Joins and Subqueries DQ Courses python , 179 , 179-8	5	345	March 5, 2020
Why can't i refer to alias for the Subquery DQ Courses python , 179 , 179-7	2	285	February 23, 2020