Treehouse | Community | Review: Aggregate and Numeric Functions

🤑 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

doesitmatter
12,885 Points
SELECT COUNT(platform) FROM games

Posted May 28, 2018 9:07am by doesitmatter

doesitmatter
12,885 Points
1 Answer
Jameel Abbess
1,402 Points
Error in Question On Reporting with SQL

Posted May 25, 2018 4:24pm by Jameel Abbess

Jameel Abbess
1,402 Points
1 Answer
Kimberly Johns
909 Points
Reporting with SQL Challenge Task

Posted May 24, 2018 6:08pm by Kimberly Johns

Kimberly Johns
909 Points
2 Answers
Fathima Fas-ha
6,847 Points
Reporting with SQL

Posted May 24, 2018 9:47am by Fathima Fas-ha

Fathima Fas-ha
6,847 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
Trouble with Challenge on Min Max values for Query

Posted May 24, 2018 3:15am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
1 Answer
Noel Thurau
1,021 Points
I'm having trouble with 2 of the quizzes.

Posted May 23, 2018 9:57pm by Noel Thurau

Noel Thurau
1,021 Points
1 Answer
Ali Ahmadian
11,474 Points
what im doing wrong?please Help!

Posted May 22, 2018 8:56pm by Ali Ahmadian

Ali Ahmadian
11,474 Points
1 Answer
Troy Erby
6,332 Points
Having trouble with Reporting SQL with the REPLACE function

Posted May 22, 2018 1:29pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
I tried with this query "SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers;" and return me "

Posted May 22, 2018 2:54am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
2 Answers
Stevan Lay
8,306 Points
What is the correct syntax here?

Posted May 21, 2018 1:42am by Stevan Lay

Stevan Lay
8,306 Points
1 Answer
Terri Valentine
23,034 Points
SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

Posted May 20, 2018 12:40am by Terri Valentine

Terri Valentine
23,034 Points
1 Answer
John Tester
3,366 Points
SQL Reporting ecommerce challenge; concatenate

Posted May 14, 2018 2:19pm by John Tester

John Tester
3,366 Points
1 Answer
ABRAHAM NYONI
9,692 Points
Can someone help me on this challenge on SQL,CALCULATING DATES.

Posted May 10, 2018 10:03am by ABRAHAM NYONI

ABRAHAM NYONI
9,692 Points
8 Answers
John Tester
3,366 Points
longest length

Posted May 9, 2018 9:41pm by John Tester

John Tester
3,366 Points
2 Answers
John Fujita
1,776 Points
Can you select all (*) but still use functions or alias certain columns without writing them all out?

Posted March 26, 2018 10:02pm by John Fujita

John Fujita
1,776 Points
1 Answer
Sean Flanagan
33,235 Points
My solution for Format Output

Posted March 24, 2018 1:17pm by Sean Flanagan

Sean Flanagan
33,235 Points
1 Answer
Sean Flanagan
33,235 Points
Loans overdue

Posted March 24, 2018 12:51pm by Sean Flanagan

Sean Flanagan
33,235 Points
4 Answers
Sean Flanagan
33,235 Points
I can't do any of these challenges

Posted March 22, 2018 10:35pm by Sean Flanagan

Sean Flanagan
33,235 Points
3 Answers
Sean Flanagan
33,235 Points
Challenge 3 - Movie Average Rating

Posted March 22, 2018 1:04am by Sean Flanagan

Sean Flanagan
33,235 Points
2 Answers
Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
"Hello you futuristic person you." Haha Andrew has grow on me a lot more over the past courses I've taken!

Posted February 27, 2018 6:59pm by Neil Bircumshaw

Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
3 Answers
Juan Emmanuel Afable
18,531 Points
I recommend changing the question to say: "count the total number of orders that was shipped and was ordered today.

Posted February 18, 2018 10:15pm by Juan Emmanuel Afable

Juan Emmanuel Afable
18,531 Points
1 Answer
Giuseppe Ardito
14,130 Points
Replacement functions with multiple conditions

Posted January 11, 2018 12:10am by Giuseppe Ardito

Giuseppe Ardito
14,130 Points
1 Answer
Atul Varma
4,285 Points
NULL VALUES

Posted December 26, 2017 3:46am by Atul Varma

Atul Varma
4,285 Points
2 Answers
nfs
35,526 Points
How to get information from a movie database? and what kind of information can we get?

Posted December 18, 2017 7:09pm by nfs

nfs
35,526 Points
2 Answers
nfs
35,526 Points
I don't understand one thing... What do we mean by "Other Databases" ???

Posted December 17, 2017 11:43am by nfs

nfs
35,526 Points
6 Answers
Allen Gonzalez
788 Points
Challenge 1 of the following quiz asks to put <> around the email

Posted November 24, 2017 2:16pm by Allen Gonzalez

Allen Gonzalez
788 Points
1 Answer
Eylon Cohen
4,779 Points
Getting the primary key of the row with the maximum value

Posted October 18, 2017 5:50pm by Eylon Cohen

Eylon Cohen
4,779 Points
1 Answer
eodell
26,386 Points
N.B Due to actors being removed from the database the 701st row has the id of 702

Posted October 5, 2017 1:25am by eodell

eodell
26,386 Points
1 Answer
Nico Leuchter
9,572 Points
Hello, I ask myself if i put EVERY function in a place where i put a column name or value.

Posted October 4, 2017 9:09am by Nico Leuchter

Nico Leuchter
9,572 Points
1 Answer
Krishna Diamesso
33,880 Points
The sql playground is missing some tables. The only table available is the actors table.

Posted September 29, 2017 12:17am by Krishna Diamesso

Krishna Diamesso
33,880 Points
3 Answers

Prev Page 16 of 18 Next

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