Treehouse | Community | Set Operations

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

abdel ahbe
Python Development Techdegree Student 2,125 Points
SELECT Name FROM Fruit WHERE Name <= 'K' UNION SELECT Name FROM Vegetable WHERE Name <= 'K'; Why is my query wrong?

Posted January 6, 2025 1:11pm by abdel ahbe

abdel ahbe
Python Development Techdegree Student 2,125 Points
2 Answers
Rosina Marchan
3,011 Points
There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table

Posted September 7, 2023 6:58pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Rosina Marchan
3,011 Points
What am I missing?

Posted September 7, 2023 6:53pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Jason Chalangary
11,695 Points
Bug in the Javascript

Posted August 16, 2023 12:39pm by Jason Chalangary

Jason Chalangary
11,695 Points
1 Answer
Anakin Bjelland
7,176 Points
I need some help with this union challenge

Posted March 30, 2023 9:40pm by Anakin Bjelland

Anakin Bjelland
7,176 Points
1 Answer
Vincent Almeroth
12,123 Points
What lesson shows use how to filter by the first letter of a column value?

Posted February 22, 2023 12:25am by Vincent Almeroth

Vincent Almeroth
12,123 Points
1 Answer
Vernon Kincaid
11,447 Points
What is a where statement that will not return a row that starts with the letter L through Z

Posted January 29, 2023 8:11pm by Vernon Kincaid

Vernon Kincaid
11,447 Points
1 Answer
Alexei Lazarowicz
5,153 Points
I have no idea how to sort the names by what letter they start with

Posted January 11, 2023 6:31am by Alexei Lazarowicz

Alexei Lazarowicz
5,153 Points
1 Answer
Spencer Lebel
3,125 Points
Code Challenge Task 3

Posted December 6, 2022 3:03am by Spencer Lebel

Spencer Lebel
3,125 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Help with Querying Relational Databases

Posted October 3, 2022 10:27pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
2 Answers
Katie Martens
1,962 Points
Need the WHERE clause?

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

Katie Martens
1,962 Points
1 Answer
Luis Brito
24,527 Points
Querying Relational Databases , Challenge Task 4 of 6

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

Luis Brito
24,527 Points
2 Answers
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
Max Toth
3,777 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,777 Points
1 Answer
Zach Shlenker
2,277 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,277 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
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
1 Answer
pashastegall
1,921 Points
Challenge 2 of 6 - A minor mistake somewhere!?

Posted October 18, 2020 6:46pm by pashastegall

pashastegall
1,921 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
2 Answers
Betlem Ferrer
347 Points
Order by

Posted August 16, 2020 2:33pm by Betlem Ferrer

Betlem Ferrer
347 Points
0 Answers
sherelle smith
1,387 Points
Hey for challenge 1 of 6. Create a distinct result. I'm getting an error "you're missing UNION keyword"

Posted August 8, 2020 8:19pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
Melina Whitlock
2,977 Points
I am confused on how to use BETWEEN an LIKE in the same UNION query statement

Posted May 5, 2020 3:47pm by Melina Whitlock

Melina Whitlock
2,977 Points
2 Answers
Stacy Villibord
2,017 Points
Task 3 of 6

Posted April 30, 2020 7:48pm by Stacy Villibord

Stacy Villibord
2,017 Points
1 Answer
jeremyguida
8,211 Points
Task 1 of 6: SQL Set Operations

Posted April 28, 2020 5:41pm by jeremyguida

jeremyguida
8,211 Points
1 Answer
Angyal István
11,324 Points
how to limit results in a string range [e.g. show all names with starting letter from 'a' to 'k']?

Posted February 13, 2020 7:09pm by Angyal István

Angyal István
11,324 Points
2 Answers
Jimmy Nguyen
8,895 Points
why doesnt this query work in bringing back distinct fruits and veggies starting with letters A-K?

Posted January 6, 2020 6:32pm by Jimmy Nguyen

Jimmy Nguyen
8,895 Points
1 Answer
Terrence Butler
1,201 Points
Stuck on problem

Posted October 24, 2019 6:09am by Terrence Butler

Terrence Butler
1,201 Points
1 Answer
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

Prev Page 1 of 2 Next

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