Treehouse | Community |

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Dan Boswell
2,570 Points
Why does my SQL statement return 0.0 when using the SUM function?

Posted August 13, 2017 6:56pm by Dan Boswell

Dan Boswell
2,570 Points
- Databases
3 Answers
PLUS

liam sheridan
Courses Plus Student 1,276 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted August 11, 2017 4:33pm by liam sheridan

liam sheridan
Courses Plus Student 1,276 Points
- Databases
1 Answer
allensimbul
3,065 Points
Database Questions

Posted August 8, 2017 11:09am by allensimbul

allensimbul
3,065 Points
- Databases
8 Answers
Bruce McMinn
10,030 Points
A different approach and learning about JOIN

Posted August 7, 2017 8:10pm by Bruce McMinn

Bruce McMinn
10,030 Points
4 Answers
Mike Booth
2,035 Points
concatenating text question 1

Posted August 2, 2017 9:58pm by Mike Booth

Mike Booth
2,035 Points
- Databases
4 Answers
PLUS

Shubham Mishra
Courses Plus Student 805 Points
Databases where autocommit is not switched ON.

Posted July 25, 2017 5:54pm by Shubham Mishra

Shubham Mishra
Courses Plus Student 805 Points
1 Answer
Vik Mi
266 Points
What is difference between sql and nosql?

Posted July 24, 2017 5:29pm by Vik Mi

Vik Mi
266 Points
2 Answers
Nobody Tebulo
13,233 Points
Your query needs didn't retireve the correct contacts.

Posted July 22, 2017 9:03am by Nobody Tebulo

Nobody Tebulo
13,233 Points
- Databases
1 Answer
Greg Kaleka
39,021 Points
Here's a slightly more complex but more dynamic solution.

Posted July 21, 2017 7:51pm by Greg Kaleka

Greg Kaleka
39,021 Points
7 Answers
Leon Ying
1,510 Points
Can someone please help on what's missing from this code?

Posted July 19, 2017 2:00pm by Leon Ying

Leon Ying
1,510 Points
- Databases
4 Answers
Charles Webb
1,542 Points
Every time I try to answer this question I get a communication error (SQL)

Posted July 17, 2017 7:24pm by Charles Webb

Charles Webb
1,542 Points
- Databases
4 Answers
donald kaiser
9,736 Points
It's saying that I'm missing the division operator but why in God's name would I need that?

Posted June 28, 2017 9:05pm by donald kaiser

donald kaiser
9,736 Points
- Databases
2 Answers
György Varga
19,198 Points
Code Challange don't accept right solution

Posted June 23, 2017 8:03pm by György Varga

György Varga
19,198 Points
- Databases
1 Answer
Monica Dhulipudi
4,075 Points
CONCAT function

Posted June 22, 2017 10:00pm by Monica Dhulipudi

Monica Dhulipudi
4,075 Points
- Databases
2 Answers
Monica Dhulipudi
4,075 Points
SELECT *FROM movies ORDER BY DESC; Will this query give me back an output? Is it incomplete statement?

Posted June 22, 2017 8:40pm by Monica Dhulipudi

Monica Dhulipudi
4,075 Points
5 Answers
PLUS

sir a
Courses Plus Student 3,692 Points
Bug when quering with derived tables

Posted June 18, 2017 10:42am by sir a

sir a
Courses Plus Student 3,692 Points
2 Answers
donald kaiser
9,736 Points
How do you add brackets in SQL?

Posted June 16, 2017 11:55pm by donald kaiser

donald kaiser
9,736 Points
- Databases
7 Answers
Adnan MERRAKCHI
2,546 Points
everthing is okey but the bummer is here :/

Posted June 16, 2017 1:51pm by Adnan MERRAKCHI

Adnan MERRAKCHI
2,546 Points
- Databases
5 Answers
PLUS

Fabio Campanini
Courses Plus Student 1,544 Points
Hi, I'm not able to overcome task 2/6 of the set operations challenges

Posted June 15, 2017 3:38pm by Fabio Campanini

Fabio Campanini
Courses Plus Student 1,544 Points
- Databases
4 Answers
PLUS

Nelson Govea
Courses Plus Student 1,951 Points
INNER JOIN DataBase

Posted June 15, 2017 12:56am by Nelson Govea

Nelson Govea
Courses Plus Student 1,951 Points
- Databases
2 Answers
Leandro Botella Penalva
17,618 Points
Subquery vs INNER JOIN

Posted June 13, 2017 10:05am by Leandro Botella Penalva

Leandro Botella Penalva
17,618 Points
4 Answers
Ruiqi Mao
16,675 Points
what's wrong with my SQL?

Posted June 12, 2017 9:44pm by Ruiqi Mao

Ruiqi Mao
16,675 Points
- Databases
1 Answer
Tim Spangler
4,827 Points
What is going on with with this code challenge? Asking for prices between and including 10.99 and 12.99.

Posted June 10, 2017 12:24pm by Tim Spangler

Tim Spangler
4,827 Points
- Databases
2 Answers
Stanislava Stoeva
131 Points
Could somebody help me with some SQL query, please?

Posted June 9, 2017 1:23pm by Stanislava Stoeva

Stanislava Stoeva
131 Points
- Databases
2 Answers
Dmitriev Denis
1,281 Points
How to make angle brackets around email column

Posted June 9, 2017 9:06am by Dmitriev Denis

Dmitriev Denis
1,281 Points
- Databases
1 Answer
PLUS

Jonathan Osteen
Courses Plus Student 4,439 Points
Why is my answer rejected? "ambiguous column name"

Posted June 4, 2017 11:27am by Jonathan Osteen

Jonathan Osteen
Courses Plus Student 4,439 Points
- Databases
2 Answers
PLUS

MANDEEP SINGH
Courses Plus Student 935 Points
why do we have to use Distinct keyword when the Group by can count and report the different set of data?

Posted April 29, 2017 3:40am by MANDEEP SINGH

MANDEEP SINGH
Courses Plus Student 935 Points
- Databases
5 Answers
Elaine Tran
809 Points
Is there a better way to solve "Find all the invalid ratings in one query." I did NOT IN (1,2,3,4,5).

Posted January 3, 2017 7:43am by Elaine Tran

Elaine Tran
809 Points
4 Answers
Jeremy Pzygode
4,499 Points
Reporting with SQL Challenge Task 1 out of 2

Posted August 27, 2016 12:10am by Jeremy Pzygode

Jeremy Pzygode
4,499 Points
- Databases
8 Answers
PLUS

Ary de Oliveira
Courses Plus Student 28,304 Points
SQL BASIC

Posted December 20, 2015 7:15pm by Ary de Oliveira

Ary de Oliveira
Courses Plus Student 28,304 Points
- Databases
9 Answers

Prev Page 302 of 389 Next

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