Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
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
Luke Otto
1,348 Points
STRFTIME Question Issue

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

Luke Otto
1,348 Points
1 Answer
Felix Belga
2,391 Points
I cannot see what is wrong with my code

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

Felix Belga
2,391 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
4,599 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
4,599 Points
2 Answers
Michael Nanni
5,917 Points
What exactly am I counting?

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

Michael Nanni
5,917 Points
0 Answers
Mark Chesney
11,668 Points
february 31

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

Mark Chesney
11,668 Points
0 Answers
Kevin Gates
14,701 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
14,701 Points
1 Answer
David Corrales
4,646 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,646 Points
1 Answer
David Corrales
4,646 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,646 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,574 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,574 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,091 Points
Today's Report challenge

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

Robbie Thomas
31,091 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,104 Points
Capital Y for years in STRFTIME function

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

Hanna Han
4,104 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
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,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
5 Answers
Sean Flanagan
33,219 Points
My solution for Format Output

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

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

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

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

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

Sean Flanagan
33,219 Points
3 Answers

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.