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

New No-Code Track! 🚀 New videos dropping every week—start learning today!

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and 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
    • Community Projects
    • Live Sessions
    • 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
  • Community Projects Live Sessions 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
  • Alexander Tomashevskiy
    Alexander Tomashevskiy
    8,326 Points

    I don't understand where is the mistake? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

    Posted April 26, 2023 12:15pm by Alexander Tomashevskiy
    Alexander Tomashevskiy
    8,326 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Miroslav Pasajlic
    Miroslav Pasajlic
    795 Points

    Question Expecting results like 'L Chalkley' not 'L Chalkley'

    Posted December 23, 2022 6:01pm by Miroslav Pasajlic
    Miroslav Pasajlic
    795 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • MARSHA OURSO
    MARSHA OURSO
    4,312 Points

    SUBSTR

    Posted October 10, 2022 2:06pm by MARSHA OURSO
    MARSHA OURSO
    4,312 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Ola Ajayi
    Ola Ajayi
    3,034 Points

    Unsure of Where I Have Gone Wrong in My Code

    Posted May 4, 2021 7:20pm by Ola Ajayi
    Ola Ajayi
    3,034 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Brian Diaz
    Brian Diaz
    2,819 Points

    Where am I going wrong?

    Posted April 1, 2021 5:14pm by Brian Diaz
    Brian Diaz
    2,819 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Jack Donaldson
    Jack Donaldson
    2,846 Points

    Unable to complete the objective. Received, "Bummer: Expecting results like L Chalkley' not 'L Chalkley'."

    Posted January 23, 2021 9:10am by Jack Donaldson
    Jack Donaldson
    2,846 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Timmy Welch
    Timmy Welch
    1,599 Points

    Getting same result as expected but not being allowed past the question.

    Posted July 4, 2020 3:27pm by Timmy Welch
    Timmy Welch
    1,599 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Ariadna Rodriguez
    Ariadna Rodriguez
    6,281 Points

    I don't understand where I should SELECT a new column and where I should concatenate the new output

    Posted July 4, 2020 9:39am by Ariadna Rodriguez
    Ariadna Rodriguez
    6,281 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Ariadna Rodriguez
    Ariadna Rodriguez
    6,281 Points

    should both columns be a substrings?

    Posted July 1, 2020 4:14am by Ariadna Rodriguez
    Ariadna Rodriguez
    6,281 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Aquoinette Blair
    Aquoinette Blair
    3,539 Points

    Bummer Error

    Posted April 24, 2020 7:50pm by Aquoinette Blair
    Aquoinette Blair
    3,539 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Ân Nguyá»…n Hoàng
    PLUS
    Ân Nguyễn Hoàng
    Courses Plus Student 3,980 Points

    is this a bug ?

    Posted March 7, 2020 11:27pm by Ân Nguyễn Hoàng
    Ân Nguyễn Hoàng
    Courses Plus Student 3,980 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • youssef b10ta
    PLUS
    youssef b10ta
    Courses Plus Student 2,755 Points

    how im supposed t understand this ? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

    Posted January 16, 2020 10:09am by youssef b10ta
    youssef b10ta
    Courses Plus Student 2,755 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • Erin DeSpain
    Erin DeSpain
    6,763 Points

    Question with Reporting with SQL Challenge 1/1 appears broken

    Posted August 10, 2019 8:10pm by Erin DeSpain
    Erin DeSpain
    6,763 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • Remi Vledder
    Remi Vledder
    14,144 Points

    "Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'." What's the difference here?

    Posted July 25, 2019 4:19pm by Remi Vledder
    Remi Vledder
    14,144 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • Christopher Endswell
    Christopher Endswell
    1,781 Points

    Getting the following error message: Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'. What is going on?

    Posted June 22, 2019 8:45am by Christopher Endswell
    Christopher Endswell
    1,781 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • omid ayoobe
    omid ayoobe
    5,274 Points

    get same results but error in code. SUBSTR(first_name,1,1)

    Posted June 20, 2019 5:12pm by omid ayoobe
    omid ayoobe
    5,274 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Namazbek Bekarysuly
    Namazbek Bekarysuly
    882 Points

    What is wrong?

    Posted February 23, 2019 12:59am by Namazbek Bekarysuly
    Namazbek Bekarysuly
    882 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Abiel Ortega
    Abiel Ortega
    2,171 Points

    I dont get it

    Posted December 27, 2018 6:34am by Abiel Ortega
    Abiel Ortega
    2,171 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Rhea Khanna
    Rhea Khanna
    2,838 Points

    Complex question please help

    Posted October 19, 2018 12:41pm by Rhea Khanna
    Rhea Khanna
    2,838 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Shain Jones
    Shain Jones
    1,315 Points

    Excerpts From Text

    Posted October 18, 2018 3:14pm by Shain Jones
    Shain Jones
    1,315 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    1 Answer

  • Marinko Klac
    Marinko Klac
    1,165 Points

    Getting the right result, but program doesn't approve it.

    Posted October 8, 2018 4:04pm by Marinko Klac
    Marinko Klac
    1,165 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • Andy McMurry
    Andy McMurry
    4,276 Points

    I think my code is right but keep getting an error message

    Posted August 11, 2018 3:36pm by Andy McMurry
    Andy McMurry
    4,276 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • Bryan Makle
    Bryan Makle
    4,531 Points

    Expecting reuslts like 'L Chalkley' not 'L Chalkley'. I need assistance please?

    Posted July 23, 2018 9:43pm by Bryan Makle
    Bryan Makle
    4,531 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

    2 Answers

  • Edgardo Tupiño
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Edgardo Tupiño
    Front End Web Development Techdegree Graduate 32,244 Points

    I tried with this query "SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers;" and return me "

    Posted May 22, 2018 2:54am by Edgardo Tupiño
    .a{fill-rule:evenodd;}techdegree seal-36
    Edgardo Tupiño
    Front End Web Development Techdegree Graduate 32,244 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Creating Excerpts

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