Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Felix Belga
1,239 Points
I cannot see what is wrong with my code

Posted May 16, 2019 6:55pm by Felix Belga

Felix Belga
1,239 Points
3 Answers
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 4:03pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
dfeem
3,818 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
3,818 Points
2 Answers
Michael Nanni
4,707 Points
What exactly am I counting?

Posted January 29, 2019 1:29pm by Michael Nanni

Michael Nanni
4,707 Points
0 Answers
Mark Chesney
11,499 Points
february 31

Posted January 12, 2019 5:20am by Mark Chesney

Mark Chesney
11,499 Points
0 Answers
Kevin Gates
13,161 Points
So if you have a date + time, and you add a year, won't the result be a date + time? I thought you had to use STRFTIME?

Posted January 7, 2019 4:53pm by Kevin Gates

Kevin Gates
13,161 Points
1 Answer
David Corrales
4,275 Points
Wow, I keep getting stumped! This might not be for me! I'm trying hard though, this challenge is kicking my butt!

Posted December 17, 2018 12:51am by David Corrales

David Corrales
4,275 Points
1 Answer
David Corrales
4,275 Points
Hi Community! Sorry to be a bother! =[ This challenge is stumping me!

Posted December 17, 2018 12:38am by David Corrales

David Corrales
4,275 Points
1 Answer
Shain Jones
1,151 Points
Calculating Dates

Posted October 26, 2018 6:10pm by Shain Jones

Shain Jones
1,151 Points
2 Answers
Rose Mathurin
2,882 Points
What am i doing wrong?

Posted October 20, 2018 8:02am by Rose Mathurin

Rose Mathurin
2,882 Points
1 Answer
Fairooz Adams
2,704 Points
What to do here?

Posted October 14, 2018 8:07pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
Karen Shumate
13,488 Points
Count the total number of orders that were ordered yesterday and have the status of 'shipped'. Alias it to ordered_yeste

Posted September 30, 2018 8:21pm by Karen Shumate

Karen Shumate
13,488 Points
1 Answer
Courage Tafadzwa Chesa
5,308 Points
Does this code work lol im now stuck

Posted September 17, 2018 1:29pm by Courage Tafadzwa Chesa

Courage Tafadzwa Chesa
5,308 Points
0 Answers
Gurdeep singh
1,522 Points
SELECT COUNT(*) AS "ordered_yesterday_and_shipped" FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", -1)

Posted August 30, 2018 3:29am by Gurdeep singh

Gurdeep singh
1,522 Points
2 Answers
Robbie Thomas
31,090 Points
Today's Report challenge

Posted August 7, 2018 3:32pm by Robbie Thomas

Robbie Thomas
31,090 Points
1 Answer
david vo
3,278 Points
reporting with sql

Posted July 25, 2018 9:37pm by david vo

david vo
3,278 Points
3 Answers
Felix Bynum
1,129 Points
Issues with dates, particularly "now"

Posted July 6, 2018 6:53pm by Felix Bynum

Felix Bynum
1,129 Points
1 Answer
Deborah Watson
2,614 Points
STRFTIME() Bummer: You may have got your params the wrong way around.

Posted June 21, 2018 5:07pm by Deborah Watson

Deborah Watson
2,614 Points
3 Answers
Hanna Han
4,103 Points
Capital Y for years in STRFTIME function

Posted June 21, 2018 5:17am by Hanna Han

Hanna Han
4,103 Points
1 Answer
Ali Ahmadian
8,525 Points
what im doing wrong?please Help!

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

Ali Ahmadian
8,525 Points
1 Answer
Stevan Lay
8,305 Points
What is the correct syntax here?

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

Stevan Lay
8,305 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
ABRAHAM NYONI
9,691 Points
Can someone help me on this challenge on SQL,CALCULATING DATES.

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

ABRAHAM NYONI
9,691 Points
3 Answers
Sean Flanagan
33,217 Points
My solution for Format Output

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

Sean Flanagan
33,217 Points
0 Answers
Sean Flanagan
33,217 Points
Loans overdue

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

Sean Flanagan
33,217 Points
3 Answers
Sean Flanagan
33,217 Points
I can't do any of these challenges

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

Sean Flanagan
33,217 Points
3 Answers
Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,596 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,596 Points
2 Answers
Juan Emmanuel Afable
18,529 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,529 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

Prev Page 1 of 2 Next

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