Treehouse | Community | Filtering by Comparing Values

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ 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

João Mendonça
2,793 Points
Stuck on SQL question, did I not SELECT?

Posted October 4, 2021 11:36am by João Mendonça

João Mendonça
2,793 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
jeehry
11,575 Points
SELECT * FROM books WHERE genre LIKE Fantasy ORDER BY first_published LIMIT 5 ASC

Posted September 19, 2021 2:26am by jeehry

jeehry
11,575 Points
2 Answers
JAVIER MATHEU
19,456 Points
Why my answer is not correct?

Posted September 14, 2021 6:21pm by JAVIER MATHEU

JAVIER MATHEU
19,456 Points
1 Answer
Tyler Young
1,581 Points
SQL Playground says ILIKE is an error

Posted September 13, 2021 9:31pm by Tyler Young

Tyler Young
1,581 Points
1 Answer
Tyler Young
1,581 Points
Why can't I use aliases for this query, following an example where first_name can be presented as "First Name"?

Posted September 10, 2021 8:03pm by Tyler Young

Tyler Young
1,581 Points
0 Answers
Fahad Ahsan
2,595 Points
SELECT JOBS.ROLE, COUNT(1) FROM EMPLOYEES JOIN JOBS ON EMPLOYEES.JOB_ID = JOBS.ID ;

Posted September 8, 2021 12:18pm by Fahad Ahsan

Fahad Ahsan
2,595 Points
1 Answer
Fahad Ahsan
2,595 Points
Stuck on challenge 2 I have this so far

Posted September 7, 2021 5:56pm by Fahad Ahsan

Fahad Ahsan
2,595 Points
1 Answer
Elise Lawrence
4,844 Points
SQL ORMs with Node.js - Unhandled Promise Rejection

Posted September 5, 2021 9:58am by Elise Lawrence

Elise Lawrence
4,844 Points
- Databases
0 Answers
chris muhirwa
1,112 Points
need help with the code challenge

Posted September 2, 2021 5:17am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
chris muhirwa
1,112 Points
need help answering the question

Posted September 2, 2021 4:48am by chris muhirwa

chris muhirwa
1,112 Points
0 Answers
chris muhirwa
1,112 Points
need help figuring out what am missing in my code

Posted September 2, 2021 3:09am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
Yeshaya Coffman
Full Stack JavaScript Techdegree Graduate 22,885 Points
Trying to install sqlite3 on a raspberry pi

Posted August 29, 2021 11:29pm by Yeshaya Coffman

Yeshaya Coffman
Full Stack JavaScript Techdegree Graduate 22,885 Points
- Databases
1 Answer
Holly Bancroft
5,162 Points
Dates in SQL

Posted August 22, 2021 11:20am by Holly Bancroft

Holly Bancroft
5,162 Points
1 Answer
J de la Torre
2,858 Points
Difference in speed/efficiency between CTEs, INTERSECT, WHERE clause solutions?

Posted August 4, 2021 7:04pm by J de la Torre

J de la Torre
2,858 Points
1 Answer
Kate Johnson
Python Development Techdegree Graduate 20,155 Points
I don't understand what is wrong with my code here. [solved]

Posted July 25, 2021 8:35pm by Kate Johnson

Kate Johnson
Python Development Techdegree Graduate 20,155 Points
1 Answer
Michael Reta
255 Points
How do I query to find all of the rows with missing data without individually typing out each column name?

Posted July 25, 2021 6:09pm by Michael Reta

Michael Reta
255 Points
1 Answer
Andy McDonald
Python Development Techdegree Graduate 13,801 Points
how to find values outside of a given range in SQL

Posted July 24, 2021 5:32am by Andy McDonald

Andy McDonald
Python Development Techdegree Graduate 13,801 Points
1 Answer
Ö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
Özgür Yildirim
4,088 Points
When inserting a row, do I have to write NULL for the id to make use of the autoincrementing property?

Posted July 15, 2021 12:39pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
1 Answer
Özgür Yildirim
4,088 Points
Solutions are shown directly at the launch of the Playground!

Posted July 14, 2021 1:21pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Adam Pearson
19,432 Points
My solution for the Rex Rios schedule

Posted July 13, 2021 10:41am by Adam Pearson

Adam Pearson
19,432 Points
- Databases
0 Answers
Kristine Williams
12,470 Points
Comment to Treehouse about tasks 3 and 4 in subqueries challenge.

Posted July 10, 2021 8:44pm by Kristine Williams

Kristine Williams
12,470 Points
- Databases
0 Answers
Ricky Redman
7,520 Points
WHERE keyword

Posted July 8, 2021 5:36pm by Ricky Redman

Ricky Redman
7,520 Points
1 Answer
Steven Crutchfield
311 Points
Syntax on SQL Alias error

Posted June 27, 2021 2:26pm by Steven Crutchfield

Steven Crutchfield
311 Points
2 Answers
Erland Van Olmen
Full Stack JavaScript Techdegree Graduate 17,825 Points
Why are we passing the "article" object to res.render() in the "/:id" GET route instead of "article.dataValues" ?

Posted June 25, 2021 12:12pm by Erland Van Olmen

Erland Van Olmen
Full Stack JavaScript Techdegree Graduate 17,825 Points
- Databases
- Find Entries
1 Answer
clarence hollins
2,301 Points
what do they mean by missing angle brackets.

Posted June 19, 2021 10:53am by clarence hollins

clarence hollins
2,301 Points
1 Answer

Prev Page 7 of 388 Next

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