Treehouse | Community | Getting Minimum and Maximum 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

Eylon Cohen
4,779 Points
Getting the second value (rather than the first) for every group of rows with the same user_id

Posted September 28, 2017 5:48pm by Eylon Cohen

Eylon Cohen
4,779 Points
1 Answer
Kevin Haller
5,940 Points
Mistake in task definition. The query wants to find out all orders, which were shipped today.

Posted September 26, 2017 9:32am by Kevin Haller

Kevin Haller
5,940 Points
1 Answer
Lax Shah
546 Points
Answer to this?

Posted September 13, 2017 5:56am by Lax Shah

Lax Shah
546 Points
1 Answer
Lax Shah
546 Points
Answer to this?

Posted September 13, 2017 5:52am by Lax Shah

Lax Shah
546 Points
0 Answers
Mike Booth
2,035 Points
Calculating Averages

Posted August 4, 2017 4:30am by Mike Booth

Mike Booth
2,035 Points
2 Answers
Monica Dhulipudi
4,075 Points
SELECT *FROM movies ORDER BY DESC; Will this query give me back an output? Is it incomplete statement?

Posted June 22, 2017 8:40pm by Monica Dhulipudi

Monica Dhulipudi
4,075 Points
5 Answers
PLUS

Manish Barik
Courses Plus Student 4,058 Points
How do I show next week in SQL, i,e. starting from coming Sunday to the following Saturday?

Posted June 6, 2017 9:40am by Manish Barik

Manish Barik
Courses Plus Student 4,058 Points
1 Answer
PLUS

Madhuri Maddala
Courses Plus Student 793 Points
Obtain the actor records between the 701st and 720th records using only LIMIT and OFFSET

Posted April 7, 2017 4:43am by Madhuri Maddala

Madhuri Maddala
Courses Plus Student 793 Points
2 Answers
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Formatting Dates in a simple way?

Posted April 4, 2017 7:26pm by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
3 Answers
Jonatan Spahn
6,362 Points
User Average Rating, a little more advanced using subqueries

Posted March 29, 2017 12:54am by Jonatan Spahn

Jonatan Spahn
6,362 Points
1 Answer
Jonatan Spahn
6,362 Points
SQL Stage 4: Practice problem.

Posted March 24, 2017 4:47am by Jonatan Spahn

Jonatan Spahn
6,362 Points
3 Answers
Jonatan Spahn
6,362 Points
Average of each movie

Posted March 23, 2017 12:58am by Jonatan Spahn

Jonatan Spahn
6,362 Points
3 Answers
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Can you combine a Substring and Replace function inside one another?

Posted March 22, 2017 12:10am by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
2 Answers
Jan Lundeen
5,886 Points
On SQL Playground, Stage 3, Practice, how do I calculate the average movie rating and round it to 1 decimal place?

Posted March 21, 2017 11:51pm by Jan Lundeen

Jan Lundeen
5,886 Points
3 Answers
Abhilasha jangid
2,925 Points
is a keyword that can be used in conjunction with LIMIT to page through results.

Posted March 21, 2017 6:00am by Abhilasha jangid

Abhilasha jangid
2,925 Points
1 Answer
Cristian Glodeanu
4,031 Points
Loans Due solution

Posted February 7, 2017 10:58am by Cristian Glodeanu

Cristian Glodeanu
4,031 Points
9 Answers
Gleb Sklyr
17,492 Points
Why is the a NULL genre value complicating this challenge and howto solve it elegantly?

Posted January 31, 2017 12:30am by Gleb Sklyr

Gleb Sklyr
17,492 Points
1 Answer
Lionel Pena
3,346 Points
AVG(<numeric column>) and WHERE

Posted January 19, 2017 3:59pm by Lionel Pena

Lionel Pena
3,346 Points
1 Answer
Cathi Row
1,231 Points
What is the correct way of using the REPLACE() function for replacing "javascript" with "JavaScript" ?

Posted December 29, 2016 9:23pm by Cathi Row

Cathi Row
1,231 Points
2 Answers
Pamela LaMarca
1,072 Points
Previous exercise - Concatenate text and place <> around email address - your examples and teaching are very unclear.

Posted December 6, 2016 3:47pm by Pamela LaMarca

Pamela LaMarca
1,072 Points
3 Answers
Rifqi Fahmi
23,164 Points
How does this DATE() function work ?

Posted December 2, 2016 2:37am by Rifqi Fahmi

Rifqi Fahmi
23,164 Points
1 Answer
Rastko Jovic
14,883 Points
I don't understand why i can't user GROUP BY and HAVING in this example.

Posted November 17, 2016 9:11am by Rastko Jovic

Rastko Jovic
14,883 Points
1 Answer
Gregory Ledger
6,116 Points
Why a comma after SELECT *

Posted November 13, 2016 1:46am by Gregory Ledger

Gregory Ledger
6,116 Points
1 Answer
orange sky
Front End Web Development Techdegree Student 4,945 Points
Replace()

Posted October 18, 2016 7:46pm by orange sky

orange sky
Front End Web Development Techdegree Student 4,945 Points
2 Answers
orange sky
Front End Web Development Techdegree Student 4,945 Points
Reporting with SQL LOWER(), and UPPER()

Posted October 18, 2016 7:19pm by orange sky

orange sky
Front End Web Development Techdegree Student 4,945 Points
1 Answer
orange sky
Front End Web Development Techdegree Student 4,945 Points
LOWER()

Posted October 13, 2016 12:26pm by orange sky

orange sky
Front End Web Development Techdegree Student 4,945 Points
2 Answers
Kristian Woods
23,414 Points
I don't fully understand how GROUB BY works...

Posted October 9, 2016 5:20pm by Kristian Woods

Kristian Woods
23,414 Points
4 Answers
Kristian Woods
23,414 Points
I don't understand the SQL REPLACE() function

Posted October 6, 2016 12:48pm by Kristian Woods

Kristian Woods
23,414 Points
7 Answers
Hemen Nabi
15,192 Points
Which one of these functions is more widely used, `substr()` or `mid()`?

Posted October 4, 2016 6:49pm by Hemen Nabi

Hemen Nabi
15,192 Points
1 Answer
David Wright
4,437 Points
Why are SQL workstations NOT saved in my workstations page on TeamTreeHouse.com?

Posted September 29, 2016 11:48am by David Wright

David Wright
4,437 Points
1 Answer

Prev Page 17 of 18 Next

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