Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Özgür Yildirim
4,088 Points
What is wrong with this query?

Posted July 17, 2021 8:39pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
Task 4 of 4 is driving me mad. Obviously I do not get it

Posted July 17, 2021 8:33pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
My subquery doesn't return all CustomerIDs for people who identify as female (F), apparently. But why?

Posted July 17, 2021 7:47pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
Difference between UNION and UNION ALL for the second practice question?

Posted July 17, 2021 7:27pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Tatia Burdett
1,463 Points
LEFT OUTER JOIN, selecting from two tables, not resulting as expected.

Posted June 12, 2021 6:13pm by Tatia Burdett

Tatia Burdett
1,463 Points
1 Answer
Ola Ajayi
3,034 Points
I Have No Idea Where I Have Gone Wrong!

Posted May 6, 2021 9:28am by Ola Ajayi

Ola Ajayi
3,034 Points
1 Answer
Max Toth
3,776 Points
Subquery in the WHERE clause not detected?

Posted April 28, 2021 2:45pm by Max Toth

Max Toth
3,776 Points
1 Answer
Max Toth
3,776 Points
I've tried both approaches to a WHERE clause limiting names to '[a-k]%' (or NOT LIKE '[l-z]%' but neither does the trick

Posted April 23, 2021 8:24pm by Max Toth

Max Toth
3,776 Points
1 Answer
Zach Shlenker
1,527 Points
I need to exclude SQL query results that start with the letters L-Z.

Posted April 14, 2021 6:33pm by Zach Shlenker

Zach Shlenker
1,527 Points
2 Answers
PLUS

Jack Chaffin
Courses Plus Student 4,459 Points
How abstract should we get with normalization using foreign keys?

Posted April 13, 2021 5:43pm by Jack Chaffin

Jack Chaffin
Courses Plus Student 4,459 Points
2 Answers
Beckett Brees
3,390 Points
I am looking for a way to create a list of all fruits and vegetable from A - K; I have used BETWEEN and the > L, help.

Posted April 6, 2021 10:47am by Beckett Brees

Beckett Brees
3,390 Points
1 Answer
Terry Zhong
4,046 Points
Possible error in video - EXCEPT venn diagram min 1:09

Posted April 3, 2021 1:47pm by Terry Zhong

Terry Zhong
4,046 Points
1 Answer
Ariana Maksimović
2,785 Points
What is normalisation of database (in SQL) ?

Posted March 18, 2021 4:24pm by Ariana Maksimović

Ariana Maksimović
2,785 Points
1 Answer
jun cheng wong
17,021 Points
Check answer for question 2

Posted March 2, 2021 9:41am by jun cheng wong

jun cheng wong
17,021 Points
0 Answers
jun cheng wong
17,021 Points
Task #3

Posted March 1, 2021 3:08pm by jun cheng wong

jun cheng wong
17,021 Points
0 Answers
wc93
25,711 Points
Having problem selecting code because the test workspaces are too close to browser edge

Posted February 6, 2021 6:09pm by wc93

wc93
25,711 Points
0 Answers
Aquoinette Blair
3,539 Points
Subquery??

Posted January 11, 2021 2:38am by Aquoinette Blair

Aquoinette Blair
3,539 Points
2 Answers
Aquoinette Blair
3,539 Points
Ambiguous Error

Posted January 11, 2021 1:48am by Aquoinette Blair

Aquoinette Blair
3,539 Points
1 Answer
Aquoinette Blair
3,539 Points
Returning non joined columns with an inner join

Posted January 11, 2021 1:23am by Aquoinette Blair

Aquoinette Blair
3,539 Points
2 Answers
Dillon Cordel
1,774 Points
I'm getting the - SQL Error: Near "ON" Syntax Error - Message. I'm not sure why.

Posted January 5, 2021 4:20pm by Dillon Cordel

Dillon Cordel
1,774 Points
0 Answers
Roxanne Reyes
9,006 Points
Need help solving this challenge to join 3 tables.

Posted December 23, 2020 6:32pm by Roxanne Reyes

Roxanne Reyes
9,006 Points
0 Answers
Ra Bha
2,201 Points
Getting error: Bummer: SQL Error: no such column: Md.VIN . Okay, but why is this the case for a LEFT INNER JOIN?

Posted December 15, 2020 4:59pm by Ra Bha

Ra Bha
2,201 Points
0 Answers
Ra Bha
2,201 Points
If the tables are aliased to md and mk, how come the column names don't change when query is run?

Posted December 15, 2020 2:59pm by Ra Bha

Ra Bha
2,201 Points
0 Answers
John Richter
2,351 Points
Not sure what the syntax error is

Posted November 20, 2020 11:25pm by John Richter

John Richter
2,351 Points
1 Answer
Ariadna Rodriguez
6,274 Points
I'm getting a syntax error and I don't know what I am missing.

Posted November 10, 2020 9:54am by Ariadna Rodriguez

Ariadna Rodriguez
6,274 Points
0 Answers
Joseph Fox
3,648 Points
I cannot figure out what I am doing wrong and this code runs properly in the playground before this quiz.

Posted November 8, 2020 9:04pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Georgina Wise
1,774 Points
Does a WHERE clause only appear at the end of a query or does it have to go both sides of the set function?

Posted November 5, 2020 3:56pm by Georgina Wise

Georgina Wise
1,774 Points
0 Answers
Pasha Stegall
1,874 Points
Challenge 2 of 6 - A minor mistake somewhere!?

Posted October 18, 2020 6:46pm by Pasha Stegall

Pasha Stegall
1,874 Points
0 Answers
Lucio Bonforte
4,164 Points
I need help please! What am I doing wrong?

Posted October 8, 2020 8:53pm by Lucio Bonforte

Lucio Bonforte
4,164 Points
1 Answer
theteamtreehouse
3,471 Points
When and where is this mentioned, what is the answer and why?

Posted August 22, 2020 2:50pm by theteamtreehouse

theteamtreehouse
3,471 Points
0 Answers

Prev Page 1 of 7 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.