Treehouse | Community | Averaging Values

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

brigitte kock
2,054 Points
Why: 'your query didn't perform the correct average calculation'? Where is my mistake in the code below?

Posted November 20, 2020 10:20am by brigitte kock

brigitte kock
2,054 Points
0 Answers
Aquoinette Blair
3,539 Points
MAX/MIN Question

Posted November 20, 2020 7:18am by Aquoinette Blair

Aquoinette Blair
3,539 Points
2 Answers
Van Nguyen
3,533 Points
Bummer said "There's only 3" but I inserted 4 values into products table

Posted November 18, 2020 11:02am by Van Nguyen

Van Nguyen
3,533 Points
1 Answer
Mehdi Datoo
2,378 Points
Stuck on this question! Please provide solution!

Posted November 14, 2020 7:40pm by Mehdi Datoo

Mehdi Datoo
2,378 Points
2 Answers
Louis Worth
4,286 Points
Reporting with SQL. Challenge task 1 of 2. am being told that my query didnt return emails in the correct format but why

Posted November 10, 2020 7:40pm by Louis Worth

Louis Worth
4,286 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I'm getting a syntax error and I don't know what I am missing.

Posted November 10, 2020 9:54am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Ra Bha
2,201 Points
Why wouldn't the query here have the last_name before the first_name?

Posted November 9, 2020 4:36pm by Ra Bha

Ra Bha
2,201 Points
1 Answer
Joseph Fox
3,648 Points
I cannot figure out what I am doing wrong and this code runs properly in the playground before this quiz.

Posted November 8, 2020 9:04pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Georgina Wise
1,774 Points
Does a WHERE clause only appear at the end of a query or does it have to go both sides of the set function?

Posted November 5, 2020 3:56pm by Georgina Wise

Georgina Wise
1,774 Points
1 Answer
Adam Meikle
6,663 Points
Expected results match actual results yet getting error code, any tips?

Posted November 4, 2020 5:29pm by Adam Meikle

Adam Meikle
6,663 Points
1 Answer
Jenn Giulietti
4,888 Points
GROUP OF ROWS SQL

Posted November 1, 2020 8:18pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jenn Giulietti
4,888 Points
SQL COUNT

Posted November 1, 2020 7:44pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
2 Answers
Jenn Giulietti
4,888 Points
CONCAT SQL

Posted November 1, 2020 7:23pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Joseph Fox
3,648 Points
Why am I having to set the values like this to display ID 700 - ID 720?

Posted October 30, 2020 8:42pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Jenn Giulietti
4,888 Points
REPLACE SQL

Posted October 30, 2020 8:21pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jenn Giulietti
4,888 Points
concatenate SQL

Posted October 30, 2020 7:44pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
2 Answers
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
I am getting the answer expected the count to be 14....

Posted October 30, 2020 6:49pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
2 Answers
Lyola Rowe
3,806 Points
Please help with this challenge

Posted October 29, 2020 5:27am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
Lyola Rowe
3,806 Points
Please help understand what I'm doing wrong here

Posted October 29, 2020 4:54am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
William Hallam
2,948 Points
Query doesn't seem to work and I cannot figure out why not.

Posted October 27, 2020 11:22am by William Hallam

William Hallam
2,948 Points
1 Answer
Lyola Rowe
3,806 Points
Need help with this query

Posted October 27, 2020 4:32am by Lyola Rowe

Lyola Rowe
3,806 Points
2 Answers
Jenn Giulietti
4,888 Points
SQL limiting difficulty

Posted October 27, 2020 12:52am by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
I really did not want to ask for help on this one as I think I understand the concept...here is the code I tried.

Posted October 26, 2020 4:02pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
2 Answers
Cole Vance
882 Points
What is my query missing? SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit";

Posted October 25, 2020 5:25pm by Cole Vance

Cole Vance
882 Points
2 Answers
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
Can't figure it out

Posted October 25, 2020 12:58am by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
4 Answers
Alex Moon
1,888 Points
Picking all the data that is null

Posted October 24, 2020 11:16pm by Alex Moon

Alex Moon
1,888 Points
2 Answers
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
SELECT * FROM products WHERE price BETWEEN >= 10.99 AND price <= 12.99;

Posted October 24, 2020 6:08pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
I'm not sure how I am writing this wrong...SELECT username FROM users WHERE last_name = "Chalkey";

Posted October 24, 2020 3:48pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
5 Answers
Lyola Rowe
3,806 Points
I'm typing this and getting "incorrect format" error. What am I doing wrong?

Posted October 21, 2020 4:29am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
pashastegall
1,921 Points
Challenge 2 of 6 - A minor mistake somewhere!?

Posted October 18, 2020 6:46pm by pashastegall

pashastegall
1,921 Points
0 Answers

Prev Page 11 of 388 Next

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

brigitte kock

brigitte kock

Aquoinette Blair

Aquoinette Blair

Van Nguyen

Van Nguyen

Mehdi Datoo

Mehdi Datoo

Louis Worth

Louis Worth

Ariadna Rodriguez

Ariadna Rodriguez

Ra Bha

Ra Bha

Joseph Fox

Joseph Fox

Georgina Wise

Georgina Wise

Adam Meikle

Adam Meikle

Jenn Giulietti

Jenn Giulietti

Jenn Giulietti

Jenn Giulietti

Jenn Giulietti

Jenn Giulietti

Joseph Fox

Joseph Fox

Jenn Giulietti

Jenn Giulietti

Jenn Giulietti

Jenn Giulietti

Jason Nutt

Jason Nutt

Lyola Rowe

Lyola Rowe

Lyola Rowe

Lyola Rowe

William Hallam

William Hallam

Lyola Rowe

Lyola Rowe

Jenn Giulietti

Jenn Giulietti

Jason Nutt

Jason Nutt

Cole Vance

Cole Vance

Jason Nutt

Jason Nutt

Alex Moon

Alex Moon

Jason Nutt

Jason Nutt

Jason Nutt

Jason Nutt

Lyola Rowe

Lyola Rowe

pashastegall

pashastegall