Treehouse | Community | Finding Data that Matches a Pattern

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ 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

Nameer Jamal
309 Points
n the e-commerce database we have a products table. The columns are id, name, description and price. Find all the produ

Posted December 10, 2023 5:05am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Rojina Pradhan
2,681 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
2,681 Points
2 Answers
Rojina Pradhan
2,681 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
2,681 Points
3 Answers
Nataliia Kalinicheva
5,433 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
5,433 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
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
17,352 Points
Question on Integer data type

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

JASON LEE
17,352 Points
1 Answer
Ryan Hartigan
3,426 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,426 Points
3 Answers
Omolade Akinwumi
1,068 Points
WHERE CONDITION

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

Omolade Akinwumi
1,068 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
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
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
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
Holly Bancroft
5,162 Points
Dates in SQL

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

Holly Bancroft
5,162 Points
1 Answer
Kate Johnson
Python Development Techdegree Graduate 20,155 Points
I don't understand what is wrong with my code here. [solved]

Posted July 25, 2021 8:35pm by Kate Johnson

Kate Johnson
Python Development Techdegree Graduate 20,155 Points
1 Answer
Michael Reta
255 Points
How do I query to find all of the rows with missing data without individually typing out each column name?

Posted July 25, 2021 6:09pm by Michael Reta

Michael Reta
255 Points
1 Answer
Andy McDonald
Python Development Techdegree Graduate 13,801 Points
how to find values outside of a given range in SQL

Posted July 24, 2021 5:32am by Andy McDonald

Andy McDonald
Python Development Techdegree Graduate 13,801 Points
1 Answer
Ricky Redman
7,520 Points
WHERE keyword

Posted July 8, 2021 5:36pm by Ricky Redman

Ricky Redman
7,520 Points
1 Answer
Joseph Bertino
Full Stack JavaScript Techdegree Student 14,652 Points
Don't provide answers to SQL Playground queries

Posted June 18, 2021 3:47pm by Joseph Bertino

Joseph Bertino
Full Stack JavaScript Techdegree Student 14,652 Points
1 Answer
Daniel Berger
4,820 Points
When using the wildcard (%) on the LIKE function, when is it appropriate to use 1 or 2 wildcards

Posted May 24, 2021 6:21pm by Daniel Berger

Daniel Berger
4,820 Points
1 Answer
sv vs
Full Stack JavaScript Techdegree Student 925 Points
Im a little bit confused about the difference between these two options in the quiz, help!!

Posted May 20, 2021 5:37pm by sv vs

sv vs
Full Stack JavaScript Techdegree Student 925 Points
1 Answer
Piotr Sochaczewski
13,038 Points
Minor mistake

Posted April 12, 2021 7:23am by Piotr Sochaczewski

Piotr Sochaczewski
13,038 Points
1 Answer
Abirame Kumarathasan
1,053 Points
code not working

Posted March 19, 2021 7:36pm by Abirame Kumarathasan

Abirame Kumarathasan
1,053 Points
1 Answer

Prev Page 1 of 6 Next

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