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
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
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
Claire Brehm
9,098 Points
Having trouble with question 3

Posted February 28, 2020 12:03am by Claire Brehm

Claire Brehm
9,098 Points
2 Answers
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
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,640 Points
Column (Name) in Second Table is Gone?

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

Dan K
10,640 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

Prev Page 1 of 3 Next

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