Treehouse | Community | Averaging Values

🤑 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

PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
AVG Help

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

Takyi Akwah
Courses Plus Student 1,049 Points
1 Answer
Gurdeep singh
1,522 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,522 Points
2 Answers
Brian Ross
11,209 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
11,209 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
2 Answers
Gurdeep singh
1,522 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,522 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
6,906 Points
Reporting with sql, 2nd code challenge COUNT BY GROUP incorrect code

Posted August 16, 2018 6:48pm by kelvinvockins

kelvinvockins
6,906 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
6,023 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
6,023 Points
1 Answer
Franklyn Gregory
12,098 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
12,098 Points
2 Answers
Amy Hsieh
6,023 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
6,023 Points
1 Answer
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
Help with Length function

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

Takyi Akwah
Courses Plus Student 1,049 Points
2 Answers
Amy Hsieh
6,023 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
6,023 Points
1 Answer
Haisam Elkewidy
26,987 Points
correct answer is being interpreted by the site as incorrect

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

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

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

Andy McMurry
4,276 Points
2 Answers
Hasan Ali
2,039 Points
Not understanding what the question is asking

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

Hasan Ali
2,039 Points
1 Answer
Robbie Thomas
31,093 Points
Today's Report challenge

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

Robbie Thomas
31,093 Points
1 Answer
Robbie Thomas
31,093 Points
SQL Min & Max

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

Robbie Thomas
31,093 Points
2 Answers
Robbie Thomas
31,093 Points
Getting the length of a string

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

Robbie Thomas
31,093 Points
1 Answer
PLUS

Richard gt
Courses Plus Student 749 Points
Summing Values

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

Richard gt
Courses Plus Student 749 Points
1 Answer
Naoya Yuda
6,185 Points
Count Function

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

Naoya Yuda
6,185 Points
2 Answers
Avid Coder
2,053 Points
Using Length Function

Posted July 26, 2018 2:00pm by Avid Coder

Avid Coder
2,053 Points
1 Answer
david vo
3,278 Points
reporting with sql

Posted July 25, 2018 9:37pm by david vo

david vo
3,278 Points
3 Answers
Avid Coder
2,053 Points
SQL help regarding aliasing

Posted July 25, 2018 4:08pm by Avid Coder

Avid Coder
2,053 Points
2 Answers
Bryan Makle
4,531 Points
Expecting reuslts like 'L Chalkley' not 'L Chalkley'. I need assistance please?

Posted July 23, 2018 9:43pm by Bryan Makle

Bryan Makle
4,531 Points
2 Answers
Bryan Makle
4,531 Points
How do I add angle brackets at the beginning and end of the email? Please assist

Posted July 23, 2018 4:54pm by Bryan Makle

Bryan Makle
4,531 Points
2 Answers
Miràs Maulenov
1,787 Points
How to find missing values in a sequence?

Posted July 21, 2018 11:15am by Miràs Maulenov

Miràs Maulenov
1,787 Points
1 Answer
Jonathan Hartmayer
5,626 Points
Average cost of order

Posted July 20, 2018 7:21am by Jonathan Hartmayer

Jonathan Hartmayer
5,626 Points
1 Answer
PLUS

Amari Hanes
Courses Plus Student 2,025 Points
select movie_id, sum(reviews) as starman_total_ratings from reviews where movie_id = 6;

Posted July 18, 2018 1:10pm by Amari Hanes

Amari Hanes
Courses Plus Student 2,025 Points
1 Answer
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
Concatenation Challenge Help

Posted July 18, 2018 11:59am by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
2 Answers

Prev Page 14 of 18 Next

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