Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Zach Johnston
568 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
568 Points
1 Answer
Luigi Cinque
1,343 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,343 Points
2 Answers
Russell Soppe
5,354 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 Russell Soppe

Russell Soppe
5,354 Points
1 Answer
Omar Nousseir
2,262 Points
What is wrong with this SQL query ? SELECT COUNT(*) FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");

Posted September 7, 2019 11:33pm by Omar Nousseir

Omar Nousseir
2,262 Points
1 Answer
Miles Eastwood
1,682 Points
How to concatenate and use an alias at the same time?

Posted September 7, 2019 3:35pm by Miles Eastwood

Miles Eastwood
1,682 Points
1 Answer
Carol Garcia
1,875 Points
Second attempt.

Posted September 2, 2019 6:59pm by Carol Garcia

Carol Garcia
1,875 Points
1 Answer
Carol Garcia
1,875 Points
Code check.

Posted September 2, 2019 6:42pm by Carol Garcia

Carol Garcia
1,875 Points
1 Answer
Carol Garcia
1,875 Points
What am I doing wrong in this query?

Posted September 2, 2019 4:38pm by Carol Garcia

Carol Garcia
1,875 Points
2 Answers
Jonathan Freire-Benites
2,234 Points
date format not accepted despite being correct

Posted August 31, 2019 8:07pm by Jonathan Freire-Benites

Jonathan Freire-Benites
2,234 Points
3 Answers
sevdiye ozlutas
1,453 Points
what should be the code for challenge 1 for finding the length of TEXT, I have tried different methods

Posted August 26, 2019 1:43pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the SQL code for challenge one? I have tried different ways but it keeps giving me an error

Posted August 26, 2019 12:52pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
3 Answers
sevdiye ozlutas
1,453 Points
I am struggling to write a query for this question. What is should be?

Posted August 26, 2019 11:09am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
0 Answers
sevdiye ozlutas
1,453 Points
What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Posted August 26, 2019 10:18am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Marcus Yang
4,612 Points
I don't know what's wrong with my SQL statement. Pls help!

Posted August 24, 2019 1:57pm by Marcus Yang

Marcus Yang
4,612 Points
2 Answers
Yung Kazi
6,978 Points
Keyword OFFSET I am actually confused about what OFFSET is doing. [SOLVED]

Posted August 24, 2019 5:35am by Yung Kazi

Yung Kazi
6,978 Points
2 Answers
Spencer Koss
1,100 Points
Capitalizing One Character in a variable from a Database

Posted August 12, 2019 7:50pm by Spencer Koss

Spencer Koss
1,100 Points
1 Answer
Cosmin Iuga
2,058 Points
Stuck here. Here's my answer so far.

Posted August 12, 2019 5:49pm by Cosmin Iuga

Cosmin Iuga
2,058 Points
2 Answers
hassan oladini
1,579 Points
Challenge task

Posted August 11, 2019 3:58pm by hassan oladini

hassan oladini
1,579 Points
1 Answer
Erin DeSpain
2,649 Points
Question with Reporting with SQL Challenge 1/1 appears broken

Posted August 10, 2019 8:10pm by Erin DeSpain

Erin DeSpain
2,649 Points
1 Answer
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,379 Points
Replace question on SQL practice

Posted August 3, 2019 10:32pm by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,379 Points
2 Answers
Cosmin Iuga
2,058 Points
Hello again.

Posted July 27, 2019 1:35pm by Cosmin Iuga

Cosmin Iuga
2,058 Points
3 Answers
Cosmin Iuga
2,058 Points
Hello. Can someone please help? Thank you kindly

Posted July 27, 2019 1:20pm by Cosmin Iuga

Cosmin Iuga
2,058 Points
1 Answer
Cosmin Iuga
2,058 Points
I'm lost here. Here's another version I tried.

Posted July 26, 2019 12:57pm by Cosmin Iuga

Cosmin Iuga
2,058 Points
2 Answers
Cosmin Iuga
2,058 Points
I'm so lost here. :(

Posted July 26, 2019 12:41pm by Cosmin Iuga

Cosmin Iuga
2,058 Points
2 Answers
Remi Vledder
12,722 Points
Is it possible to UPPER(<column>) a single column, and returning all other columns without having to specify them?

Posted July 25, 2019 5:12pm by Remi Vledder

Remi Vledder
12,722 Points
0 Answers
Remi Vledder
12,722 Points
"Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'." What's the difference here?

Posted July 25, 2019 4:19pm by Remi Vledder

Remi Vledder
12,722 Points
2 Answers
Luke Otto
1,348 Points
STRFTIME Question Issue

Posted July 7, 2019 10:44pm by Luke Otto

Luke Otto
1,348 Points
1 Answer
Christopher Endswell
1,781 Points
Getting the following error message: Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'. What is going on?

Posted June 22, 2019 8:45am by Christopher Endswell

Christopher Endswell
1,781 Points
2 Answers
omid ayoobe
5,274 Points
get same results but error in code. SUBSTR(first_name,1,1)

Posted June 20, 2019 5:12pm by omid ayoobe

omid ayoobe
5,274 Points
1 Answer
Adam Tyler
5,095 Points
Why does this need a WHERE clause?

Posted June 19, 2019 4:02pm by Adam Tyler

Adam Tyler
5,095 Points
1 Answer

Prev Page 1 of 11 Next

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