Treehouse | Community | Filtering by Dates

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Beckett Brees
3,390 Points
I am being told I am missing a column but cannot find it - id, home_team, home_score, away_team, away_score, played_on.

Posted March 17, 2021 10:07am by Beckett Brees

Beckett Brees
3,390 Points
1 Answer
Tremayne Moncrief
2,324 Points
I am trying to answer this question and I keep getting an error stating something is wrong with my SQL statement.

Posted January 26, 2021 3:02am by Tremayne Moncrief

Tremayne Moncrief
2,324 Points
1 Answer
Ra Bha
2,201 Points
Last Name Cruise

Posted November 27, 2020 10:32pm by Ra Bha

Ra Bha
2,201 Points
1 Answer
Ra Bha
2,201 Points
Find all actors whos first name starts with Will - not sure how to do this one

Posted November 27, 2020 10:20pm by Ra Bha

Ra Bha
2,201 Points
3 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
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
Leslie Whitford
714 Points
What am I doing wrong in my command?

Posted September 10, 2020 6:50pm by Leslie Whitford

Leslie Whitford
714 Points
1 Answer
Shain Jones
1,315 Points
BETWEEN , SELECT statement

Posted August 28, 2020 6:03pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Shain Jones
1,315 Points
seems to be simple but I am missing something. task is get results of home team scores <=. Not liking my syntax

Posted August 28, 2020 2:06pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
SHAWNELL HARRISON
16,282 Points
Can someone please help me?

Posted August 26, 2020 9:55pm by SHAWNELL HARRISON

SHAWNELL HARRISON
16,282 Points
1 Answer
CarteA Sharrock
4,860 Points
I am inputting my code as: SELECT * FROM results WHERE id = "Hessle" AND played_on >= "2015-10-01"; what is wrong?

Posted August 3, 2020 3:44pm by CarteA Sharrock

CarteA Sharrock
4,860 Points
2 Answers
Joe Li
3,234 Points
What column am I missing from my query?

Posted May 28, 2020 4:34pm by Joe Li

Joe Li
3,234 Points
2 Answers
Stacy Villibord
2,017 Points
Challange Task

Posted April 22, 2020 2:38am by Stacy Villibord

Stacy Villibord
2,017 Points
2 Answers
Dennis Dumbreni
14,146 Points
search

Posted April 18, 2020 6:54pm by Dennis Dumbreni

Dennis Dumbreni
14,146 Points
1 Answer
Farfetch UK Spinetto
2,139 Points
Hello, I don't understand why my answer is incorrect

Posted April 16, 2020 8:42am by Farfetch UK Spinetto

Farfetch UK Spinetto
2,139 Points
0 Answers
Bas Spijker
353 Points
Hello. I got stuck with this database challenge. Could someone provide me the correct query?

Posted April 14, 2020 6:14pm by Bas Spijker

Bas Spijker
353 Points
2 Answers
A X
12,842 Points
What is a Foreign Key?

Posted March 30, 2020 10:35pm by A X

A X
12,842 Points
2 Answers
Ashish Thannippara
2,793 Points
hello the code section is broken and will not assess my code or let me progress with the course?

Posted March 19, 2020 10:06pm by Ashish Thannippara

Ashish Thannippara
2,793 Points
2 Answers
Brendan Quinn
2,847 Points
Hi guys, I am having difficulty with the challenge task please help :)

Posted March 18, 2020 1:19pm by Brendan Quinn

Brendan Quinn
2,847 Points
1 Answer
pratyush raj
7,097 Points
why he used id=15 instead of book_id=15???

Posted March 18, 2020 7:23am by pratyush raj

pratyush raj
7,097 Points
1 Answer
Richard Sun
11,257 Points
What is wrong with this query?

Posted March 14, 2020 11:19pm by Richard Sun

Richard Sun
11,257 Points
1 Answer
Ellen Longman
144 Points
what's wrong with code?

Posted March 8, 2020 4:31pm by Ellen Longman

Ellen Longman
144 Points
1 Answer
Ellen Longman
144 Points
wrong with code?

Posted March 8, 2020 3:54pm by Ellen Longman

Ellen Longman
144 Points
1 Answer
mihneaburtescu
348 Points
I dont understand

Posted February 28, 2020 5:02am by mihneaburtescu

mihneaburtescu
348 Points
1 Answer
Claire Uzenski
1,026 Points
having trouble with SQL, this is what I have so far, SELECT 'Hessle' FROM away_team WHERE results = 2015-10-01

Posted January 23, 2020 2:36pm by Claire Uzenski

Claire Uzenski
1,026 Points
4 Answers
Claire Uzenski
1,026 Points
Need more help with SQL basics, having trouble with more of the equations

Posted January 20, 2020 1:18pm by Claire Uzenski

Claire Uzenski
1,026 Points
8 Answers
Claire Uzenski
1,026 Points
How do i complete the equation

Posted January 16, 2020 2:24pm by Claire Uzenski

Claire Uzenski
1,026 Points
1 Answer
vona goodpaster
1,719 Points
keeps stating: Did you select from "results" table My answer: SELECT * FROM results WHERE away_team < 10;

Posted January 6, 2020 8:22pm by vona goodpaster

vona goodpaster
1,719 Points
1 Answer

Prev Page 2 of 6 Next

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