Treehouse | Community | Calculating the Minimum and Maximum Values

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ 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

Derek Morse
1,776 Points
A little Lost what am i missing

Posted May 18, 2020 4:39pm by Derek Morse

Derek Morse
1,776 Points
8 Answers
Derek Morse
1,776 Points
missing a step?

Posted May 18, 2020 4:15pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
Data line does not match, what distinct am i missing?

Posted May 18, 2020 3:45pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
rajpal Saini
2,331 Points
cant find the solution for challenge task 2 of 2

Posted April 28, 2020 11:59am by rajpal Saini

rajpal Saini
2,331 Points
1 Answer
Caleb Newell
12,562 Points
SUM()

Posted April 22, 2020 2:32pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
lucas morrow
2,243 Points
query didn't match

Posted April 21, 2020 2:58am by lucas morrow

lucas morrow
2,243 Points
1 Answer
Taylor Han
2,406 Points
(SQL) Finding the sum

Posted April 20, 2020 9:23pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Iona Loveridge
574 Points
Why is this line wrong? SELECT COUNT(*) FROM books AS "scifi_book_count" WHERE genre = "Science Fiction"

Posted April 20, 2020 5:33pm by Iona Loveridge

Iona Loveridge
574 Points
1 Answer
Taylor Han
2,406 Points
Counting with SQL

Posted April 17, 2020 10:59pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Kawaljeet Singh
3,820 Points
AVG

Posted April 17, 2020 12:42pm by Kawaljeet Singh

Kawaljeet Singh
3,820 Points
2 Answers
Kawaljeet Singh
3,820 Points
GROUP BY

Posted April 17, 2020 9:29am by Kawaljeet Singh

Kawaljeet Singh
3,820 Points
1 Answer
Caleb Newell
12,562 Points
Write a query to count all the unique genres in the books table. Alias it as total_genres.

Posted April 9, 2020 1:26pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Freddie Kuhle
8,037 Points
SQL - How can I add a column from one table to my results from another table?

Posted March 30, 2020 10:31am by Freddie Kuhle

Freddie Kuhle
8,037 Points
1 Answer
Tafari Carnegie
2,679 Points
select genre,count(distinct genre) as total_genres from books group by genre

Posted March 25, 2020 10:15pm by Tafari Carnegie

Tafari Carnegie
2,679 Points
1 Answer
Riley Egan
2,452 Points
I'm at a loss as far as what to do. I've re-watched the video several times and cannot get past this point.

Posted November 20, 2019 7:47pm by Riley Egan

Riley Egan
2,452 Points
2 Answers
Jerry Lombardo
945 Points
Getting the Grand Total exercise

Posted November 1, 2019 9:36pm by Jerry Lombardo

Jerry Lombardo
945 Points
1 Answer
Jerry Lombardo
945 Points
Count Challenge Task 1

Posted October 29, 2019 7:15pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
newtocoding
4,940 Points
How to answer this challenge?

Posted September 25, 2019 12:17pm by newtocoding

newtocoding
4,940 Points
2 Answers
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
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
sofia Heikkila Svensson
3,695 Points
Hi, My code is wrong. The bummer answer is : You should try writing a SELECT query.

Posted April 18, 2019 7:33am by sofia Heikkila Svensson

sofia Heikkila Svensson
3,695 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
taherkhan
4,327 Points
Query regarding calculating average

Posted March 24, 2019 9:46am by taherkhan

taherkhan
4,327 Points
1 Answer
Ker Sing Tan
10,573 Points
solve missing where cause error

Posted March 17, 2019 7:42am by Ker Sing Tan

Ker Sing Tan
10,573 Points
1 Answer
Shahrukh Siddiqui
2,698 Points
UNABLE TO WRITE THE QUERY

Posted March 6, 2019 5:51am by Shahrukh Siddiqui

Shahrukh Siddiqui
2,698 Points
1 Answer
Satyam garhewal
326 Points
Why my query is not working, can you please help me out?

Posted March 1, 2019 5:46am by Satyam garhewal

Satyam garhewal
326 Points
2 Answers
william gallagher
1,919 Points
What is wrong with my code?

Posted February 11, 2019 1:43am by william gallagher

william gallagher
1,919 Points
1 Answer
Harris Handoko
3,932 Points
Why is the WHERE clause required here instead of the HAVING clause?

Posted February 1, 2019 2:24am by Harris Handoko

Harris Handoko
3,932 Points
1 Answer
Richard Külling
9,465 Points
I don't see what's wrong with my query, it seems that it returns what is asked for, doesn't it?

Posted January 19, 2019 6:35pm by Richard Külling

Richard Külling
9,465 Points
1 Answer
Thomas Wilson
18,741 Points
I keep getting the wrong sum but I don't know what I'm doing wrong.

Posted January 17, 2019 2:53pm by Thomas Wilson

Thomas Wilson
18,741 Points
1 Answer

Prev Page 2 of 4 Next

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