Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Katie Martens
1,587 Points
Subquery using IN

Posted July 19, 2022 8:01pm by Katie Martens

Katie Martens
1,587 Points
1 Answer
Katie Martens
1,587 Points
Need the WHERE clause?

Posted July 18, 2022 8:54pm by Katie Martens

Katie Martens
1,587 Points
1 Answer
Katie Martens
1,587 Points
Inner Join

Posted June 28, 2022 8:41pm by Katie Martens

Katie Martens
1,587 Points
2 Answers
Luis Brito
23,874 Points
Querying Relational Databases , Challenge Task 4 of 6

Posted May 27, 2022 8:20pm by Luis Brito

Luis Brito
23,874 Points
2 Answers
Omolade Akinwumi
1,068 Points
JOIN

Posted March 25, 2022 8:35am by Omolade Akinwumi

Omolade Akinwumi
1,068 Points
1 Answer
Omolade Akinwumi
1,068 Points
JOIN

Posted March 24, 2022 4:53pm by Omolade Akinwumi

Omolade Akinwumi
1,068 Points
0 Answers
Nirujan Baheerathan
4,387 Points
In a car database there is a Sale table with columns, SaleID, CarID, CustomerID, LocationID, SalesRepID, SaleAmount and

Posted March 23, 2022 11:38am by Nirujan Baheerathan

Nirujan Baheerathan
4,387 Points
1 Answer
Leigh Maher
21,830 Points
Is it realistic for this relationship to be one-to-many?

Posted March 11, 2022 11:27am by Leigh Maher

Leigh Maher
21,830 Points
2 Answers
Deangelo Robinson
1,438 Points
I keep getting question 5 wrong so I can't move to the next step.

Posted March 3, 2022 8:25pm by Deangelo Robinson

Deangelo Robinson
1,438 Points
1 Answer
Deangelo Robinson
1,438 Points
Did anyone get the correct syntax for this?

Posted March 3, 2022 5:44pm by Deangelo Robinson

Deangelo Robinson
1,438 Points
1 Answer
Fred Russell
1,545 Points
Join returning seemingly too many (duplicate) rows.

Posted March 1, 2022 4:07pm by Fred Russell

Fred Russell
1,545 Points
1 Answer
yelena shakhanova
1,257 Points
any advise why this isn't accepting the code?

Posted February 18, 2022 6:13pm by yelena shakhanova

yelena shakhanova
1,257 Points
2 Answers
pinky
2,188 Points
can i please get some help with this challenge task 4 join queries?

Posted February 6, 2022 7:09pm by pinky

pinky
2,188 Points
0 Answers
pinky
2,188 Points
saying im missing the left key, Please someone help me?

Posted February 1, 2022 6:52pm by pinky

pinky
2,188 Points
1 Answer
Carlos Esquivel
3,587 Points
How to use SQL INNER JOIN to display Data from three different tables on a report.

Posted December 27, 2021 9:05pm by Carlos Esquivel

Carlos Esquivel
3,587 Points
1 Answer
Garrett Harriman
4,171 Points
Cannot Pass Challenge 2 of 6: SQL Set Operations Review (Fruit and Vegetables)

Posted September 28, 2021 11:50pm by Garrett Harriman

Garrett Harriman
4,171 Points
2 Answers
Ö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
1 Answer
Ö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,470 Points
LEFT OUTER JOIN, selecting from two tables, not resulting as expected.

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

Tatia Burdett
1,470 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
2,050 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
2,050 Points
2 Answers
PLUS

Jack Chaffin
Courses Plus Student 4,462 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,462 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,058 Points
Possible error in video - EXCEPT venn diagram min 1:09

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

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

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

Ariana Maksimović
2,797 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

Prev Page 1 of 8 Next

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