Skip to main content

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

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

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

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • 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
  • 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.

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

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

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord