Treehouse | Community | Set Operations

🤑 Join the Treehouse affiliate program and earn 25% commission!

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Peris Kwamboka
1,382 Points
Need help on returning fruits and vegetables with letters A to K - Task 2 challenge

Posted June 17, 2019 6:13am by Peris Kwamboka

Peris Kwamboka
1,382 Points
2 Answers
Brian Poirier
7,678 Points
select fruit and vegetables. what's wrong with this? SELECT * FROM fruit UNION SELECT * FROM vegetable

Posted March 22, 2019 2:25am by Brian Poirier

Brian Poirier
7,678 Points
1 Answer
Michael Nanni
7,358 Points
How do I filter query results between a range of starting letters?

Posted March 15, 2019 2:12am by Michael Nanni

Michael Nanni
7,358 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
How to reset the MakeID with the correct order ID?

Posted March 5, 2019 6:21am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
2 Answers
Dan K
10,689 Points
Column (Name) in Second Table is Gone?

Posted February 16, 2019 5:39am by Dan K

Dan K
10,689 Points
2 Answers
Hans Eisenman
1,315 Points
How do you build a Where clause that selects out all words which start with letters A-K?

Posted February 14, 2019 2:47pm by Hans Eisenman

Hans Eisenman
1,315 Points
4 Answers
Gia Hoang Nguyen
4,137 Points
Select * from Fruit Union Select * from Vegetable; I cant pass the challenge that asks to Create a distinct result"

Posted January 23, 2019 4:52am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer
Alvand Hajizadeh
2,069 Points
Can't get question 2 for set questions.

Posted January 9, 2019 2:28am by Alvand Hajizadeh

Alvand Hajizadeh
2,069 Points
2 Answers
David Corrales
4,698 Points
Something is missing to organize this, can someone help? I appreciate you!!

Posted December 19, 2018 9:51am by David Corrales

David Corrales
4,698 Points
1 Answer
PLUS

naveen rajavasireddy
Courses Plus Student 1,783 Points
Query works in SQL Playground but fails in quiz

Posted December 14, 2018 11:32pm by naveen rajavasireddy

naveen rajavasireddy
Courses Plus Student 1,783 Points
2 Answers
Stephen Robinson
7,461 Points
Why is my question being marked wrong when it is right?

Posted October 30, 2018 8:41pm by Stephen Robinson

Stephen Robinson
7,461 Points
2 Answers
Darran-Nehru Ram-Nehru
3,053 Points
Need help in the where condition for Names only starting between A through K.

Posted October 13, 2018 12:07pm by Darran-Nehru Ram-Nehru

Darran-Nehru Ram-Nehru
3,053 Points
1 Answer
Darran-Nehru Ram-Nehru
3,053 Points
Need help in the where condition for Names only starting between A through K.

Posted October 13, 2018 12:07pm by Darran-Nehru Ram-Nehru

Darran-Nehru Ram-Nehru
3,053 Points
0 Answers
Robert Edwardes
15,777 Points
Using union all and not getting correct result

Posted September 15, 2018 10:28pm by Robert Edwardes

Robert Edwardes
15,777 Points
1 Answer
Gurdeep singh
1,522 Points
Need to know What's wrong with this code

Posted September 13, 2018 3:05pm by Gurdeep singh

Gurdeep singh
1,522 Points
2 Answers
Montellas Whiteside
6,059 Points
IDKwhy this code don't work

Posted August 28, 2018 7:05pm by Montellas Whiteside

Montellas Whiteside
6,059 Points
1 Answer
Amadou Diallo
5,373 Points
Why don't we just use INNER JOIN instead of INTERSECT?

Posted August 25, 2018 9:18pm by Amadou Diallo

Amadou Diallo
5,373 Points
1 Answer
Robbie Thomas
31,093 Points
Set Operations 2 of 6

Posted August 17, 2018 4:30pm by Robbie Thomas

Robbie Thomas
31,093 Points
1 Answer
victorvillaplana
11,582 Points
Problem with task 2 of 6

Posted August 5, 2018 4:03pm by victorvillaplana

victorvillaplana
11,582 Points
2 Answers
lukej
34,222 Points
Task 2 of the Code Challenge

Posted August 1, 2018 7:16pm by lukej

lukej
34,222 Points
2 Answers
Alejandro Romero Parra
1,593 Points
GET a Bummer IDK why

Posted July 16, 2018 1:45am by Alejandro Romero Parra

Alejandro Romero Parra
1,593 Points
1 Answer
Hanna Han
4,105 Points
Unions require the number of columns...

Posted June 28, 2018 3:38am by Hanna Han

Hanna Han
4,105 Points
2 Answers
Hannah Tucker McLellan
1,856 Points
Why doesn't my query work? Name of Fruit and Veg between A - K

Posted June 22, 2018 9:38am by Hannah Tucker McLellan

Hannah Tucker McLellan
1,856 Points
2 Answers
Odane Williams
6,692 Points
I followed all the examples but I'm getting an error that says the query is not returning through A and K.

Posted June 15, 2018 6:28pm by Odane Williams

Odane Williams
6,692 Points
1 Answer
Jonathan Whittle
28,309 Points
Limiting Results by First Letter of Name

Posted June 14, 2018 10:43pm by Jonathan Whittle

Jonathan Whittle
28,309 Points
1 Answer
Patty Johnson
26,560 Points
Create an alphabetical list of produce that is considered both a fruit and a vegetable.

Posted June 14, 2018 9:04pm by Patty Johnson

Patty Johnson
26,560 Points
1 Answer
Daniele Santos
16,536 Points
Querying issues SELECT Name FROM Fruit UNION SELECT Name FROM Vegetable WHERE Name BETWEEN "A" AND "K";

Posted May 31, 2018 1:43pm by Daniele Santos

Daniele Santos
16,536 Points
1 Answer
Tracy Chacon
7,372 Points
Having trouble sorting columns A through K and not L to Z in SQL.

Posted May 30, 2018 8:34pm by Tracy Chacon

Tracy Chacon
7,372 Points
1 Answer
Troy Erby
6,332 Points
Trouble with Set Operations

Posted May 25, 2018 5:49pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Mark Mazur Lussenburg
25,338 Points
Challenge task 2 relational databases SET OPERATIONS

Posted May 23, 2018 2:42pm by Mark Mazur Lussenburg

Mark Mazur Lussenburg
25,338 Points
2 Answers

Prev Page 2 of 3 Next

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