Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Kevin May
1,305 Points
When asked "Write a query to count all the unique genres in the books table. Alias it as total_genres." get wrong count?

Posted September 19, 2018 2:04pm by Kevin May

Kevin May
1,305 Points
2 Answers
Courage Tafadzwa Chesa
3,602 Points
Does this code work lol im now stuck

Posted September 17, 2018 1:29pm by Courage Tafadzwa Chesa

Courage Tafadzwa Chesa
3,602 Points
0 Answers
Kevin Matter
870 Points
Question Bug

Posted September 16, 2018 3:26pm by Kevin Matter

Kevin Matter
870 Points
2 Answers
Sam Beattie
700 Points
I don't know what I'm missing on this challenge in the Reporting with SQL track. I need to "Alias it to to_field."

Posted September 11, 2018 8:13pm by Sam Beattie

Sam Beattie
700 Points
3 Answers
PRO

Ethan Martin
Pro Student 1,230 Points
Retrieving Data - SELECT, LIMIT, OFFSET

Posted September 7, 2018 7:20pm by Ethan Martin

Ethan Martin
Pro Student 1,230 Points
2 Answers
Daniel Sparks
715 Points
I am having trouble with the following prompt:

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

Daniel Sparks
715 Points
1 Answer
PRO

ct7
Pro Student 328 Points
Challenge task 1 of 2

Posted September 1, 2018 7:29pm by ct7

ct7
Pro Student 328 Points
2 Answers
Daniel Sparks
715 Points
Stuck on a training challenge...

Posted August 31, 2018 5:56pm by Daniel Sparks

Daniel Sparks
715 Points
1 Answer
Domenic Crump
463 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
463 Points
2 Answers
PRO

Takyi Akwah
Pro Student 1,049 Points
AVG Help

Posted August 30, 2018 8:08pm by Takyi Akwah

Takyi Akwah
Pro Student 1,049 Points
1 Answer
Gurdeep singh
1,393 Points
SELECT COUNT(*) AS "ordered_yesterday_and_shipped" FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", -1)

Posted August 30, 2018 3:29am by Gurdeep singh

Gurdeep singh
1,393 Points
2 Answers
Brian Ross
9,395 Points
Getting a weird error: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001".

Posted August 26, 2018 11:04pm by Brian Ross

Brian Ross
9,395 Points
5 Answers
jon snow
1,774 Points
which database treehouse playground uses?

Posted August 26, 2018 1:18am by jon snow

jon snow
1,774 Points
1 Answer
Gurdeep singh
1,393 Points
SELECT COUNT(*) AS "jk_book_count" FROM books WHERE author = "J.K.Rowling" ; I don't know what wrong with this script

Posted August 24, 2018 10:51pm by Gurdeep singh

Gurdeep singh
1,393 Points
1 Answer
Erin Clayton
3,840 Points
What am I doing wrong?

Posted August 24, 2018 1:52am by Erin Clayton

Erin Clayton
3,840 Points
2 Answers
kelvinvockins
3,362 Points
Reporting with sql, 2nd code challenge COUNT BY GROUP incorrect code

Posted August 16, 2018 6:48pm by kelvinvockins

kelvinvockins
3,362 Points
2 Answers
Branislav Galovic
713 Points
Challenge 2

Posted August 14, 2018 8:34pm by Branislav Galovic

Branislav Galovic
713 Points
1 Answer
Amy Hsieh
3,084 Points
To generate a count of certain column. I can't see what's wrong with my SQL code

Posted August 14, 2018 11:30am by Amy Hsieh

Amy Hsieh
3,084 Points
1 Answer
Franklyn Gregory
11,191 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name,

Posted August 14, 2018 6:55am by Franklyn Gregory

Franklyn Gregory
11,191 Points
2 Answers
Amy Hsieh
3,084 Points
I can't see where the problem is. The system message: Your query needs didn't retireve the emails in the correct form

Posted August 13, 2018 5:15am by Amy Hsieh

Amy Hsieh
3,084 Points
1 Answer
PRO

Takyi Akwah
Pro Student 1,049 Points
Help with Length function

Posted August 12, 2018 11:10am by Takyi Akwah

Takyi Akwah
Pro Student 1,049 Points
2 Answers
Amy Hsieh
3,084 Points
Q: The page can display 20 entries, I am asked to display the 3rd page of results.

Posted August 12, 2018 7:21am by Amy Hsieh

Amy Hsieh
3,084 Points
1 Answer
Haisam Elkewidy
4,924 Points
correct answer is being interpreted by the site as incorrect

Posted August 11, 2018 5:34pm by Haisam Elkewidy

Haisam Elkewidy
4,924 Points
1 Answer
Andy McMurry
1,872 Points
I think my code is right but keep getting an error message

Posted August 11, 2018 3:36pm by Andy McMurry

Andy McMurry
1,872 Points
2 Answers
Hasan Ali
1,720 Points
Not understanding what the question is asking

Posted August 8, 2018 12:34am by Hasan Ali

Hasan Ali
1,720 Points
1 Answer
Robbie Thomas
30,707 Points
Today's Report challenge

Posted August 7, 2018 3:32pm by Robbie Thomas

Robbie Thomas
30,707 Points
1 Answer
Robbie Thomas
30,707 Points
SQL Min & Max

Posted August 6, 2018 3:47pm by Robbie Thomas

Robbie Thomas
30,707 Points
2 Answers
Robbie Thomas
30,707 Points
Getting the length of a string

Posted August 2, 2018 3:13pm by Robbie Thomas

Robbie Thomas
30,707 Points
1 Answer
PRO

Richard gt
Pro Student 749 Points
Summing Values

Posted August 1, 2018 5:34pm by Richard gt

Richard gt
Pro Student 749 Points
1 Answer
Naoya Yuda
2,575 Points
Count Function

Posted July 31, 2018 7:36am by Naoya Yuda

Naoya Yuda
2,575 Points
2 Answers

Prev Page 1 of 6 Next

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