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
  • Hank Boudreau
    Hank Boudreau
    804 Points

    How to omit ellipses in the Truncate Names problem that are less than 10?

    Posted January 23, 2022 2:05am by Hank Boudreau
    Hank Boudreau
    804 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    1 Answer

  • Jay Narain
    Jay Narain
    2,311 Points

    In the SQL playground there is the assignment "review attribution". but we do not know how to change the column order?

    Posted April 24, 2020 4:58pm by Jay Narain
    Jay Narain
    2,311 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    4 Answers

  • Kimberlee Johnson
    Kimberlee Johnson
    5,343 Points

    Small typo in "Changine" questions (SQL Playground - Stage 2 Practice)?

    Posted October 23, 2019 5:47pm by Kimberlee Johnson
    Kimberlee Johnson
    5,343 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    1 Answer

  • Jesse Dispoto
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Jesse Dispoto
    Front End Web Development Techdegree Graduate 14,538 Points

    Replace question on SQL practice

    Posted August 3, 2019 10:32pm by Jesse Dispoto
    .a{fill-rule:evenodd;}techdegree seal-36
    Jesse Dispoto
    Front End Web Development Techdegree Graduate 14,538 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    4 Answers

  • Remi Vledder
    Remi Vledder
    14,144 Points

    Is it possible to UPPER(<column>) a single column, and returning all other columns without having to specify them?

    Posted July 25, 2019 5:12pm by Remi Vledder
    Remi Vledder
    14,144 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    0 Answers

  • John Fujita
    John Fujita
    1,776 Points

    Can you select all (*) but still use functions or alias certain columns without writing them all out?

    Posted March 26, 2018 10:02pm by John Fujita
    John Fujita
    1,776 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    1 Answer

  • tonypitkin2
    PLUS
    tonypitkin2
    Courses Plus Student 1,950 Points

    Can you combine a Substring and Replace function inside one another?

    Posted March 22, 2017 12:10am by tonypitkin2
    tonypitkin2
    Courses Plus Student 1,950 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    2 Answers

  • Jonathan Grieve
    MOD
    Jonathan Grieve
    Treehouse Moderator 91,254 Points

    Final Question of the Playground Practice

    Posted March 4, 2016 5:40pm by Jonathan Grieve
    Jonathan Grieve
    Treehouse Moderator 91,254 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Practice Session

    20 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.