Treehouse | Community | Counting Groups

🤑 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

Zach Johnston
2,500 Points
I'm not sure how this isn't pulling the correct count. SELECT COUNT(genre) AS genre_count FROM books GROUP BY genre

Posted September 16, 2019 10:43pm by Zach Johnston

Zach Johnston
2,500 Points
1 Answer
Luigi Cinque
1,548 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,548 Points
2 Answers
Luigi Cinque
1,548 Points
SQL %

Posted September 15, 2019 6:51pm by Luigi Cinque

Luigi Cinque
1,548 Points
1 Answer
Unsubscribed User
8,428 Points
Not sure what I am missing, eyes going crossed. If you can help me see the invisible I would be grateful.

Posted September 13, 2019 3:13pm by Unsubscribed User

Unsubscribed User
8,428 Points
1 Answer
PLUS

Emily Payne
Courses Plus Student 6,433 Points
Where is the MongoDB course?

Posted September 10, 2019 5:11pm by Emily Payne

Emily Payne
Courses Plus Student 6,433 Points
- Databases
2 Answers
Elizabeth Hinson
Full Stack JavaScript Techdegree Graduate 15,852 Points
eCommerce Database modification

Posted September 10, 2019 2:47pm by Elizabeth Hinson

Elizabeth Hinson
Full Stack JavaScript Techdegree Graduate 15,852 Points
2 Answers
Omar Nousseir
2,262 Points
What is wrong with this SQL query ? SELECT COUNT(*) FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");

Posted September 7, 2019 11:33pm by Omar Nousseir

Omar Nousseir
2,262 Points
1 Answer
Miles Eastwood
1,682 Points
How to concatenate and use an alias at the same time?

Posted September 7, 2019 3:35pm by Miles Eastwood

Miles Eastwood
1,682 Points
1 Answer
Cliona Dowling
559 Points
What is incorrect in this query:

Posted September 4, 2019 4:01pm by Cliona Dowling

Cliona Dowling
559 Points
1 Answer
wordsisillusions
10,717 Points
My SQL professor said that Oracle RDBMS requires Windows O/S but I have a macbook with windows O/S on it, would it work?

Posted September 3, 2019 10:23pm by wordsisillusions

wordsisillusions
10,717 Points
- Databases
0 Answers
Carol Garcia
1,875 Points
Second attempt.

Posted September 2, 2019 6:59pm by Carol Garcia

Carol Garcia
1,875 Points
1 Answer
Carol Garcia
1,875 Points
Code check.

Posted September 2, 2019 6:42pm by Carol Garcia

Carol Garcia
1,875 Points
1 Answer
Carol Garcia
1,875 Points
What am I doing wrong in this query?

Posted September 2, 2019 4:38pm by Carol Garcia

Carol Garcia
1,875 Points
2 Answers
Tommy Gebru
30,164 Points
Solution: Finding the Troublemaker

Posted August 31, 2019 8:58pm by Tommy Gebru

Tommy Gebru
30,164 Points
1 Answer
Jonathan Freire-Benites
2,234 Points
date format not accepted despite being correct

Posted August 31, 2019 8:07pm by Jonathan Freire-Benites

Jonathan Freire-Benites
2,234 Points
3 Answers
Tommy Gebru
30,164 Points
Solution: JANIS Schedule

Posted August 31, 2019 4:52pm by Tommy Gebru

Tommy Gebru
30,164 Points
1 Answer
Dharmesh Nayee
1,090 Points
Why does my foreign key constrant not work?

Posted August 30, 2019 7:13pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
Dharmesh Nayee
1,090 Points
I get the Bummer message saying that i need to add the 4 columns. What is wrong with my code?

Posted August 29, 2019 9:00pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
Sung-Fu Han
3,890 Points
why the query won't work in task 2 of 3? SELECT * FROM　products WHERE price != 9.99;

Posted August 29, 2019 9:27am by Sung-Fu Han

Sung-Fu Han
3,890 Points
2 Answers
sevdiye ozlutas
1,453 Points
what should be the code for challenge 1 for finding the length of TEXT, I have tried different methods

Posted August 26, 2019 1:43pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the SQL code for challenge one? I have tried different ways but it keeps giving me an error

Posted August 26, 2019 12:52pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
3 Answers
sevdiye ozlutas
1,453 Points
I am struggling to write a query for this question. What is should be?

Posted August 26, 2019 11:09am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Posted August 26, 2019 10:18am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Paul Brubaker
14,290 Points
Forgot about HAVING keyword and came up with this monstrosity.

Posted August 26, 2019 3:37am by Paul Brubaker

Paul Brubaker
14,290 Points
3 Answers
Marcus Yang
7,476 Points
I don't know what's wrong with my SQL statement. Pls help!

Posted August 24, 2019 1:57pm by Marcus Yang

Marcus Yang
7,476 Points
2 Answers
Yung Kazi
6,997 Points
Keyword OFFSET I am actually confused about what OFFSET is doing. [SOLVED]

Posted August 24, 2019 5:35am by Yung Kazi

Yung Kazi
6,997 Points
2 Answers
Tommy Gebru
30,164 Points
Treehouse workspaces SQL playground

Posted August 23, 2019 4:08pm by Tommy Gebru

Tommy Gebru
30,164 Points
- Databases
0 Answers
Tommy Gebru
30,164 Points
Challenge Task 4 of 4 Bummer: SQL Error: near "SELECT": syntax error

Posted August 22, 2019 10:12pm by Tommy Gebru

Tommy Gebru
30,164 Points
2 Answers
shiny peanut
5,113 Points
AS Keyword in SQL

Posted August 18, 2019 4:02pm by shiny peanut

shiny peanut
5,113 Points
3 Answers
Yusuf Balogun
1,829 Points
In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name.

Posted August 17, 2019 11:24pm by Yusuf Balogun

Yusuf Balogun
1,829 Points
1 Answer

Prev Page 21 of 388 Next

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