You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • Aiya Ayazbayeva
    Aiya Ayazbayeva
    3,524 Points

    The hint says "did you select from the results table" and I did so I am not sure why the answer is incorrect

    Posted August 1, 2025 4:09pm by Aiya Ayazbayeva
    Aiya Ayazbayeva
    3,524 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Rojina Pradhan
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    2 Answers

  • Nataliia Kalinicheva
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Wufei Hong
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Joel Fuster
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Jinamai Joseph
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Spencer Lebel
    Spencer Lebel
    3,125 Points

    Need assistance filtering by dates

    Posted August 29, 2022 8:17pm by Spencer Lebel
    Spencer Lebel
    3,125 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Zachary Baca
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    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
    .a{fill-rule:evenodd;}techdegree seal-36
    Zachary Baca
    Full Stack JavaScript Techdegree Graduate 13,982 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Kate Johnson
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    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
    .a{fill-rule:evenodd;}techdegree seal-36
    Kate Johnson
    Python Development Techdegree Graduate 20,155 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Beckett Brees
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • CarteA Sharrock
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    2 Answers

  • Claire Uzenski
    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
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    4 Answers

  • Cosmin Iuga
    Cosmin Iuga
    2,352 Points

    I'm stuck. Sorry

    Posted July 22, 2019 10:03pm by Cosmin Iuga
    Cosmin Iuga
    2,352 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    2 Answers

  • Cosmin Iuga
    Cosmin Iuga
    2,352 Points

    I'm stuck here.

    Posted July 22, 2019 7:30pm by Cosmin Iuga
    Cosmin Iuga
    2,352 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    3 Answers

  • Cosmin Iuga
    Cosmin Iuga
    2,352 Points

    I can't move on here.

    Posted July 20, 2019 2:55pm by Cosmin Iuga
    Cosmin Iuga
    2,352 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    6 Answers

  • Ariel Escalante
    Ariel Escalante
    1,012 Points

    I have selected all columns but the error message is telling me I have not selected all columns

    Posted July 20, 2019 12:20am by Ariel Escalante
    Ariel Escalante
    1,012 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    2 Answers

  • Ker Sing Tan
    Ker Sing Tan
    10,573 Points

    Code Challenge: Task 1 of 1

    Posted March 12, 2019 3:28pm by Ker Sing Tan
    Ker Sing Tan
    10,573 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    3 Answers

  • Sandeep Padda
    Sandeep Padda
    2,781 Points

    how would i answer this challenge?

    Posted October 15, 2018 4:29pm by Sandeep Padda
    Sandeep Padda
    2,781 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    2 Answers

  • Phillip Blake
    Phillip Blake
    1,182 Points

    Problem while trying to filter by Dates

    Posted October 9, 2018 11:28pm by Phillip Blake
    Phillip Blake
    1,182 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    1 Answer

  • Thue Madsen
    Thue Madsen
    4,258 Points

    "You didn't select all columns" but there are not more columns.

    Posted October 3, 2018 8:05pm by Thue Madsen
    Thue Madsen
    4,258 Points
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates

    3 Answers

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

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.