Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

imjane
6,116 Points
SELECT * FROM books WHERE genre LIKE Fantasy ORDER BY first_published LIMIT 5 ASC

Posted September 19, 2021 2:26am by imjane

imjane
6,116 Points
0 Answers
JAVIER MATHEU
18,497 Points
Why my answer is not correct?

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

JAVIER MATHEU
18,497 Points
1 Answer
Tyler Young
589 Points
SQL Playground says ILIKE is an error

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

Tyler Young
589 Points
1 Answer
Tyler Young
589 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
589 Points
0 Answers
Fahad Ahsan
2,594 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,594 Points
1 Answer
Fahad Ahsan
2,594 Points
Stuck on challenge 2 I have this so far

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

Fahad Ahsan
2,594 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
PLUS

chris muhirwa
Courses Plus Student 901 Points
need help with the code challenge

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

chris muhirwa
Courses Plus Student 901 Points
0 Answers
PLUS

chris muhirwa
Courses Plus Student 901 Points
need help answering the question

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

chris muhirwa
Courses Plus Student 901 Points
0 Answers
PLUS

chris muhirwa
Courses Plus Student 901 Points
need help figuring out what am missing in my code

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

chris muhirwa
Courses Plus Student 901 Points
1 Answer
Yeshaya Coffman
Full Stack JavaScript Techdegree Student 20,227 Points
Trying to install sqlite3 on a raspberry pi

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

Yeshaya Coffman
Full Stack JavaScript Techdegree Student 20,227 Points
- Databases
0 Answers
Holly Bancroft
4,631 Points
Dates in SQL

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

Holly Bancroft
4,631 Points
0 Answers
J de la Torre
2,855 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,855 Points
1 Answer
Kate Johnson
5,711 Points
I don't understand what is wrong with my code here. [solved]

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

Kate Johnson
5,711 Points
0 Answers
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
4,988 Points
how to find values outside of a given range in SQL

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

Andy McDonald
4,988 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
0 Answers
Ö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
0 Answers
Ö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,292 Points
My solution for the Rex Rios schedule

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

Adam Pearson
19,292 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,300 Points
WHERE keyword

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

Ricky Redman
7,300 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,824 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,824 Points
- Databases
- Find Entries
0 Answers
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
Joseph Bertino
Full Stack JavaScript Techdegree Student 13,943 Points
Don't provide answers to SQL Playground queries

Posted June 18, 2021 3:47pm by Joseph Bertino

Joseph Bertino
Full Stack JavaScript Techdegree Student 13,943 Points
0 Answers
Anna Shepilova
4,128 Points
What is the solution for this question?

Posted June 17, 2021 2:51pm by Anna Shepilova

Anna Shepilova
4,128 Points
0 Answers

Prev Page 1 of 366 Next

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