Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Vincent Almeroth
9,913 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
9,913 Points
1 Answer
Vernon Kincaid
1,786 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
1,786 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
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
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,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,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,259 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,259 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
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

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.