Treehouse | Community | Counting Groups

💥 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

Jose Lopez
2,278 Points
I'm trying to count unique genres in books and I can't figure it out.

Posted November 2, 2018 3:20pm by Jose Lopez

Jose Lopez
2,278 Points
1 Answer
Shain Jones
1,315 Points
Calculating Dates

Posted October 26, 2018 6:10pm by Shain Jones

Shain Jones
1,315 Points
2 Answers
Kjetil-Lennart A. Lorentzen
13,390 Points
Where should we do calculations?

Posted October 25, 2018 7:35am by Kjetil-Lennart A. Lorentzen

Kjetil-Lennart A. Lorentzen
13,390 Points
- Databases
1 Answer
pegamoose
16,046 Points
SQL Challenge Task errors out on submission

Posted October 23, 2018 9:39pm by pegamoose

pegamoose
16,046 Points
- Databases
1 Answer
Seho Kim
2,677 Points
insert into products (id, name, description, price) value (NULL, "driver", "impact driver", 80.99);

Posted October 23, 2018 1:18pm by Seho Kim

Seho Kim
2,677 Points
1 Answer
Rhea Khanna
2,838 Points
Paging through results

Posted October 19, 2018 5:43pm by Rhea Khanna

Rhea Khanna
2,838 Points
1 Answer
Rhea Khanna
2,838 Points
Finding data using SQL

Posted October 19, 2018 11:32am by Rhea Khanna

Rhea Khanna
2,838 Points
1 Answer
Rhea Khanna
2,838 Points
Concatenate/ Alias help

Posted October 19, 2018 11:18am by Rhea Khanna

Rhea Khanna
2,838 Points
4 Answers
Rhea Khanna
2,838 Points
Paging with SQL, Limit/ Offset

Posted October 18, 2018 11:30am by Rhea Khanna

Rhea Khanna
2,838 Points
3 Answers
Sandeep Padda
2,781 Points
please help!

Posted October 16, 2018 1:42am by Sandeep Padda

Sandeep Padda
2,781 Points
4 Answers
Sam Beattie
2,413 Points
Not sure what I have wrong. Can you help?

Posted October 15, 2018 4:48am by Sam Beattie

Sam Beattie
2,413 Points
2 Answers
Fairooz Adams
2,704 Points
What to do here?

Posted October 14, 2018 8:07pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
jay aljoe
4,113 Points
Why couldn't we just use mongoose method findByIdAndUpdate()? Is there particular reason for making,own update method

Posted October 13, 2018 9:47pm by jay aljoe

jay aljoe
4,113 Points
- Databases
1 Answer
PLUS

David Ryan
Courses Plus Student 14,981 Points
MongoDB installation

Posted October 11, 2018 9:16pm by David Ryan

David Ryan
Courses Plus Student 14,981 Points
4 Answers
Karen Shumate
13,579 Points
Write a query that will retrieve all email addresses but will replace the @ symbol with <at> so they all look like andre

Posted September 29, 2018 10:31pm by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Karen Shumate
13,579 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_publishedcolumn.

Posted September 29, 2018 1:35am by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Harshay Raipancholi
Python Development Techdegree Student 12,404 Points
load() doesn't work on windows

Posted September 27, 2018 1:32pm by Harshay Raipancholi

Harshay Raipancholi
Python Development Techdegree Student 12,404 Points
1 Answer
Sonia Cabon
1,173 Points
bummer: you're missing the where cause

Posted September 24, 2018 9:47am by Sonia Cabon

Sonia Cabon
1,173 Points
3 Answers
elomaur
5,276 Points
How can I show all periods without using a CTE?

Posted September 21, 2018 3:05am by elomaur

elomaur
5,276 Points
3 Answers
Sean McLeskey
2,033 Points
Why am I seeing an "ambiguous column name" error when I'm trying to join tables if the column name is spelled correctly?

Posted September 17, 2018 10:32pm by Sean McLeskey

Sean McLeskey
2,033 Points
2 Answers
Gurdeep singh
1,522 Points
NEED HELP SQL SUBQUERY IT'S difficult

Posted September 16, 2018 9:04am by Gurdeep singh

Gurdeep singh
1,522 Points
- Databases
1 Answer
Matthew Stevenson
4,877 Points
I'm trying to take Task #3 a little further by returning only the most recent loan for each book/patron.

Posted September 13, 2018 12:50am by Matthew Stevenson

Matthew Stevenson
4,877 Points
- Databases
4 Answers
Shain Jones
1,315 Points
Help with multiple conditions

Posted September 12, 2018 6:58pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Daniel Sparks
2,695 Points
I am having trouble with the following prompt:

Posted September 4, 2018 7:50pm by Daniel Sparks

Daniel Sparks
2,695 Points
1 Answer
Domenic Crump
2,707 Points
How do you concatenate 3 columns?? I'm so confused, it's Challenge Question 1 Reporting w/ SQL

Posted August 31, 2018 5:55pm by Domenic Crump

Domenic Crump
2,707 Points
2 Answers
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Enter a review for E.T. Use a username and review of your choosing.

Posted August 31, 2018 3:55pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
- Databases
2 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
MOD

Jonathan Grieve
Treehouse Moderator 91,254 Points
Problem installing Mongo-Hacker on Windows.

Posted June 3, 2016 9:59pm by Jonathan Grieve

Jonathan Grieve
Treehouse Moderator 91,254 Points
8 Answers

Prev Page 338 of 389 Next

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