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

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

New No-Code Track! 🚀start learning today!

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

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

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

  • 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
      • • Android
      • • 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
    • Showing results for:
    • Databases
    • SQL Basics
    • Finding the Data You Want
    • Filtering by Dates
    • Close
  • 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 on Oct 3, 2023 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 on Sep 27, 2023 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 on Mar 4, 2023 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 on Feb 12, 2023 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 on Oct 21, 2022 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 on Aug 29, 2022 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 on Aug 27, 2022 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 on Jul 25, 2021 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 on Mar 17, 2021 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 on Aug 3, 2020 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 on Jan 23, 2020 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 on Jul 22, 2019 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 on Jul 22, 2019 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 on Jul 20, 2019 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 on Jul 20, 2019 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 on Mar 12, 2019 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 on Oct 15, 2018 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 on Oct 9, 2018 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 on Oct 3, 2018 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.