Treehouse | Community | Calculating Dates

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

Join the Treehouse affiliate program and earn 25% recurring commission!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Invalid Ratings

Posted August 27, 2018 9:56pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
1 Answer
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Who are these Actors?

Posted August 27, 2018 9:47pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
4 Answers
Gregory Ely
787 Points
I am pretty sure I have typed in the 'create' parameter correctly. I also attempted to remove table and it said no such

Posted August 25, 2018 2:09am by Gregory Ely

Gregory Ely
787 Points
4 Answers
Erin Clayton
3,840 Points
What's up with the SQL Playground mismatch on this video??

Posted August 20, 2018 12:33am by Erin Clayton

Erin Clayton
3,840 Points
1 Answer
kelvinvockins
6,906 Points
Reporting with sql, 2nd code challenge COUNT BY GROUP incorrect code

Posted August 16, 2018 6:48pm by kelvinvockins

kelvinvockins
6,906 Points
2 Answers
Amy Hsieh
6,023 Points
I can't see where the problem is. The system message: Your query needs didn't retireve the emails in the correct form

Posted August 13, 2018 5:15am by Amy Hsieh

Amy Hsieh
6,023 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
Cant write the correct query. Need help

Posted August 6, 2018 5:32pm by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
4 Answers
Robbie Thomas
31,093 Points
SQL Min & Max

Posted August 6, 2018 3:47pm by Robbie Thomas

Robbie Thomas
31,093 Points
2 Answers
Naoya Yuda
6,185 Points
Count Function

Posted July 31, 2018 7:36am by Naoya Yuda

Naoya Yuda
6,185 Points
2 Answers
david vo
3,278 Points
reporting with sql

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

david vo
3,278 Points
3 Answers
Bryan Makle
4,531 Points
Expecting reuslts like 'L Chalkley' not 'L Chalkley'. I need assistance please?

Posted July 23, 2018 9:43pm by Bryan Makle

Bryan Makle
4,531 Points
2 Answers
Jonathan Hartmayer
5,626 Points
Average cost of order

Posted July 20, 2018 7:21am by Jonathan Hartmayer

Jonathan Hartmayer
5,626 Points
1 Answer
Deborah Watson
2,614 Points
Make sure you're creating all 4 columns: id, first_name, last_name, and favorite_rock_id.

Posted July 18, 2018 8:25pm by Deborah Watson

Deborah Watson
2,614 Points
2 Answers
Deborah Watson
2,614 Points
FOREIGN KEY CONSTRAINT IN SQL LITE

Posted July 17, 2018 6:06pm by Deborah Watson

Deborah Watson
2,614 Points
1 Answer
Daniele Fusari
40,669 Points
CREATE TABLE MEMBERS (ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK)

Posted July 16, 2018 7:40pm by Daniele Fusari

Daniele Fusari
40,669 Points
1 Answer
Alejandro Romero Parra
1,593 Points
GET a Bummer IDK why

Posted July 16, 2018 1:45am by Alejandro Romero Parra

Alejandro Romero Parra
1,593 Points
1 Answer
PLUS

Amari Hanes
Courses Plus Student 2,025 Points
I am trouble with the concat function in sql

Posted July 15, 2018 2:44pm by Amari Hanes

Amari Hanes
Courses Plus Student 2,025 Points
2 Answers
Michael Pashkov
22,024 Points
Hi guys, should I write keywords in upper case or there is no differens?

Posted July 14, 2018 8:07am by Michael Pashkov

Michael Pashkov
22,024 Points
2 Answers
Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
Can anybody help me find this answer

Posted July 14, 2018 1:07am by Ronald Greer

Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
1 Answer
Lauren Hansson
5,754 Points
Authenticating a form w/out pug?

Posted June 26, 2018 4:40pm by Lauren Hansson

Lauren Hansson
5,754 Points
- Databases
3 Answers
Killeon Patterson
18,528 Points
Adding Data to MongoDB

Posted June 22, 2018 5:38pm by Killeon Patterson

Killeon Patterson
18,528 Points
- Databases
8 Answers
Zach Bucek
10,798 Points
Deprecated setup method?

Posted June 15, 2018 5:10pm by Zach Bucek

Zach Bucek
10,798 Points
5 Answers
Sipann A.
30,234 Points
SQL - Querying Relational databases - Challenge Task #3

Posted September 16, 2017 1:05pm by Sipann A.

Sipann A.
30,234 Points
- Databases
2 Answers
Monica Dhulipudi
4,075 Points
SELECT *FROM movies ORDER BY DESC; Will this query give me back an output? Is it incomplete statement?

Posted June 22, 2017 8:40pm by Monica Dhulipudi

Monica Dhulipudi
4,075 Points
5 Answers
Sanjay Dulal
1,269 Points
We have an eCommerce database and it has a products table. It has the columns id, name, description and price.

Posted April 29, 2017 2:58pm by Sanjay Dulal

Sanjay Dulal
1,269 Points
- Databases
4 Answers
Marius Unknown
12,925 Points
How to setup MongoDB on Windows CMD or GitBash with shortcuts.

Posted January 14, 2017 12:10pm by Marius Unknown

Marius Unknown
12,925 Points
2 Answers
Gabriel E
8,916 Points
Count was wrong, expected 14. Not sure how to manipulate this.

Posted April 14, 2016 4:24pm by Gabriel E

Gabriel E
8,916 Points
- Databases
5 Answers

Prev Page 307 of 389 Next

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