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

AI can only take you so far. 🌟 Start with core skills in JavaScript, HTML, CSS, or 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

AI can only take you so far. 🌟 Start with core skills in JavaScript, HTML, CSS, or Python. 🚀

  • 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

SQL Basics

  • Searching Tables with 'WHERE' 7:27
  • Searching Tables with 'WHERE' 3 objectives
  • Filtering by Comparing Values 3:58
  • Filtering by Comparing Values 3 objectives
  • Filtering on More than One Condition 2:51
  • Filtering on More than One Condition 2 objectives
  • Filtering by Dates 2:30
  • Filtering by Dates 1 objective
  • Searching Within a Set of Values 2:35
  • Searching Within a Set of Values 2 objectives
  • Searching Within a Range of Values 2:57
  • Searching Within a Range of Values 2 objectives
  • Finding Data that Matches a Pattern 2:43
  • Finding Data that Matches a Pattern 2 objectives
  • Filtering Out or Finding Missing Information 1:58
  • Filtering Out or Finding Missing Information 2 objectives
  • Review & Practice with SQL Playgrounds 3:50
  • instruction Need SQL Practice?
  • Finding the Data You Want Review 15 questions

Well done!

You have completed Finding the Data You Want Review!

Sign up for Treehouse Back to Library

Quiz Question 1 of 15

You have a table full of words. You want to find all words ending with tion at the end.

Which query would most likely display the correct results?

Choose the correct answer below:

Skip Quiz Review Video
  • A
    SELECT word FROM words WHERE word LIKE "tion%";
  • B
    SELECT word FROM words WHERE word LIKE "%tion%";
  • C
    SELECT word FROM words WHERE word LIKE "tion";
  • D
    
    SELECT word FROM words WHERE word LIKE "%tion";
    
Report Question

    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.

Report this Question

There was an error while reporting the question. Please try again, or contact support directly.

Describe the issue (optional) (required)

Your feedback has been submitted.
Thank you!

Oh no!

If you continue experiencing problems, please contact support at help@teamtreehouse.com.

Your Exam Has Ended

Sign up for Treehouse!

Quizzes are the best way to test your knowlege. Sign up for Treehouse today and prove yourself. We guarantee 100% satisfaction.

Free trial Sign in Back to overview