Treehouse | Community | Filtering by Dates

Jump into our new React Basics course 😎

Learn about our new Community Discord server here and join us on Discord here!

Get job-ready with our Career Toolbox Track's career advice, resume tips, and more 🧰

Probe The AI Multiverse: Exploring the Subfields of Artificial Intelligence 😮

Students: got a cool project or resource to share? Submit it to Treehouse Links! 🤩

Learn about our new Community Discord server here and join us on Discord here!

🤖 Check out all our AI content here 👀

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Rojina Pradhan
229 Points
Find all the matches in the results table where "Hessle" was playing away as the away team and if they played on or afte

Posted October 3, 2023 2:19pm by Rojina Pradhan

Rojina Pradhan
229 Points
2 Answers
Rojina Pradhan
229 Points
We're back using the e-commerce database. I only have 10.99 left in my bank account. Write a query that will return all

Posted October 2, 2023 6:05pm by Rojina Pradhan

Rojina Pradhan
229 Points
3 Answers
Nataliia Kalinicheva
1,044 Points
I selected 6 columns from 6 and I've got "You didn't select all columns". What should I do?

Posted September 27, 2023 7:54pm by Nataliia Kalinicheva

Nataliia Kalinicheva
1,044 Points
1 Answer
Jace Vanwagoner
6,767 Points
How can I save the SQL Playground practice's to be able to add them to a portfolio???

Posted May 24, 2023 3:14pm by Jace Vanwagoner

Jace Vanwagoner
6,767 Points
1 Answer
Wufei Hong
1,393 Points
don't know what's wrong wiz my code

Posted March 4, 2023 1:51am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Joel Fuster
2,429 Points
Are you able to review my script? It returns incorrect but I can't seem to figure out why

Posted February 12, 2023 2:25pm by Joel Fuster

Joel Fuster
2,429 Points
1 Answer
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Import Table in my VS code

Posted January 13, 2023 1:33pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Miroslav Pasajlic
795 Points
The columns you selected were named Home Team, Home Score, Away team, Away Score, Date Played and not 'Home Team', 'Home

Posted December 20, 2022 2:36pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
1 Answer
Jinamai Joseph
1,773 Points
What should be done when "you did not select all columns" appear? All columns are selected.

Posted October 21, 2022 2:29pm by Jinamai Joseph

Jinamai Joseph
1,773 Points
1 Answer
Spencer Lebel
3,125 Points
Need assistance filtering by dates

Posted August 29, 2022 8:17pm by Spencer Lebel

Spencer Lebel
3,125 Points
1 Answer
Zachary Baca
Full Stack JavaScript Techdegree Graduate 13,982 Points
Not sure what is wrong with this sql statement

Posted August 27, 2022 9:06pm by Zachary Baca

Zachary Baca
Full Stack JavaScript Techdegree Graduate 13,982 Points
1 Answer
Tyler McDonald
Full Stack JavaScript Techdegree Graduate 16,700 Points
More efficient way to solve "Movies with Any Missing Data"?

Posted August 19, 2022 8:35pm by Tyler McDonald

Tyler McDonald
Full Stack JavaScript Techdegree Graduate 16,700 Points
1 Answer
JASON LEE
16,475 Points
Question on Integer data type

Posted June 15, 2022 1:38am by JASON LEE

JASON LEE
16,475 Points
1 Answer
Ryan Hartigan
3,425 Points
Why do we put the date range within parenthesis when we don't put numbers within parenthesis? Is this unique to MySQL?

Posted May 7, 2022 4:38pm by Ryan Hartigan

Ryan Hartigan
3,425 Points
3 Answers
PLUS

Angelus Taylor
Courses Plus Student 1,414 Points
This is not working. When I submit my answer, it times out.

Posted March 26, 2022 5:48am by Angelus Taylor

Angelus Taylor
Courses Plus Student 1,414 Points
1 Answer
Omolade Akinwumi
1,068 Points
WHERE CONDITION

Posted March 25, 2022 8:33am by Omolade Akinwumi

Omolade Akinwumi
1,068 Points
2 Answers
K. Brice Perez
15,095 Points
How do I write an as function to retrieve the product name and product description

Posted March 3, 2022 5:48pm by K. Brice Perez

K. Brice Perez
15,095 Points
2 Answers
james mchugh
6,234 Points
It's telling me I didn't select all columns. I did and I checked the snytax and still getting this error

Posted February 17, 2022 3:00am by james mchugh

james mchugh
6,234 Points
1 Answer
PLUS

Jaqua Starr
Courses Plus Student 972 Points
It keeps saying there is something wrong with my statement, am I missing something?

Posted February 10, 2022 6:45pm by Jaqua Starr

Jaqua Starr
Courses Plus Student 972 Points
0 Answers
Lacey Walker
294 Points
It's saying I'm not selecting from the results table when I am

Posted December 14, 2021 7:27pm by Lacey Walker

Lacey Walker
294 Points
1 Answer
Anne Olaribigbe
154 Points
My code is not working Here is the code

Posted November 7, 2021 7:43pm by Anne Olaribigbe

Anne Olaribigbe
154 Points
1 Answer
keronn byrd
149 Points
What are all the products in the products table? Title of your question keronn byrd

Posted November 2, 2021 10:35pm by keronn byrd

keronn byrd
149 Points
1 Answer
nicolaspeterson
8,569 Points
In another video, Andrew used NOT IS instead.

Posted October 24, 2021 9:44am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
Christopher Carey
151 Points
Can you explain how the answer data type is incorrect?

Posted October 5, 2021 10:27pm by Christopher Carey

Christopher Carey
151 Points
1 Answer
João Mendonça
2,793 Points
Stuck on SQL question, did I not SELECT?

Posted October 4, 2021 11:36am by João Mendonça

João Mendonça
2,793 Points
1 Answer
Tyler Young
1,581 Points
Why can't I use aliases for this query, following an example where first_name can be presented as "First Name"?

Posted September 10, 2021 8:03pm by Tyler Young

Tyler Young
1,581 Points
0 Answers
chris muhirwa
1,112 Points
need help with the code challenge

Posted September 2, 2021 5:17am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
chris muhirwa
1,112 Points
need help answering the question

Posted September 2, 2021 4:48am by chris muhirwa

chris muhirwa
1,112 Points
0 Answers
chris muhirwa
1,112 Points
need help figuring out what am missing in my code

Posted September 2, 2021 3:09am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
Holly Bancroft
5,162 Points
Dates in SQL

Posted August 22, 2021 11:20am by Holly Bancroft

Holly Bancroft
5,162 Points
1 Answer

Prev Page 1 of 9 Next

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