• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Library
  • Community
  • Support
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Go
      • • HTML
      • • iOS
      • • Java
      • • JavaScript
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
      • • WordPress
  • Sam Beattie
    Sam Beattie
    700 Points

    I don't know what I'm missing on this challenge in the Reporting with SQL track. I need to "Alias it to to_field."

    Posted September 11, 2018 8:13pm by Sam Beattie
    Sam Beattie
    700 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    3 Answers

  • Daniel Sparks
    Daniel Sparks
    715 Points

    Stuck on a training challenge...

    Posted August 31, 2018 5:56pm by Daniel Sparks
    Daniel Sparks
    715 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Domenic Crump
    Domenic Crump
    463 Points

    How do you concatenate 3 columns?? I'm so confused, it's Challenge Question 1 Reporting w/ SQL

    Posted August 31, 2018 5:55pm by Domenic Crump
    Domenic Crump
    463 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Branislav Galovic
    Branislav Galovic
    713 Points

    Challenge 2

    Posted August 14, 2018 8:34pm by Branislav Galovic
    Branislav Galovic
    713 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Franklyn Gregory
    Franklyn Gregory
    11,191 Points

    In the library database there's a patrons table listing all the users of the library. The columns are id, first_name,

    Posted August 14, 2018 6:55am by Franklyn Gregory
    Franklyn Gregory
    11,191 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Amy Hsieh
    Amy Hsieh
    3,084 Points

    I can't see where the problem is. The system message: Your query needs didn't retireve the emails in the correct form

    Posted August 13, 2018 5:15am by Amy Hsieh
    Amy Hsieh
    3,084 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Avid Coder
    Avid Coder
    1,938 Points

    SQL help regarding aliasing

    Posted July 25, 2018 4:08pm by Avid Coder
    Avid Coder
    1,938 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Bryan Makle
    Bryan Makle
    4,531 Points

    How do I add angle brackets at the beginning and end of the email? Please assist

    Posted July 23, 2018 4:54pm by Bryan Makle
    Bryan Makle
    4,531 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Takyi Akwah
    PRO
    Takyi Akwah
    Pro Student 1,049 Points

    Concatenation Challenge Help

    Posted July 18, 2018 11:59am by Takyi Akwah
    Takyi Akwah
    Pro Student 1,049 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Amari Hanes
    PRO
    Amari Hanes
    Pro Student 1,980 Points

    concat function sql

    Posted July 15, 2018 2:58pm by Amari Hanes
    Amari Hanes
    Pro Student 1,980 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    0 Answers

  • Amari Hanes
    PRO
    Amari Hanes
    Pro Student 1,980 Points

    I am trouble with the concat function in sql

    Posted July 15, 2018 2:44pm by Amari Hanes
    Amari Hanes
    Pro Student 1,980 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Scott McDowell
    PRO
    Scott McDowell
    Pro Student 1,233 Points

    I can't solve this code

    Posted July 1, 2018 12:48am by Scott McDowell
    Scott McDowell
    Pro Student 1,233 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • joshua inyang
    joshua inyang
    948 Points

    Hello I'm a not understanding this can someone assist I thought this was saying to concatenate first, last, email?

    Posted June 19, 2018 4:58pm by joshua inyang
    joshua inyang
    948 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    3 Answers

  • Lisa Simpson
    Lisa Simpson
    31,448 Points

    Concatination

    Posted June 12, 2018 10:05am by Lisa Simpson
    Lisa Simpson
    31,448 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Michael Martin
    Michael Martin
    3,635 Points

    What is wrong with my syntax?

    Posted June 12, 2018 3:43am by Michael Martin
    Michael Martin
    3,635 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Michael Martin
    Michael Martin
    3,635 Points

    This statement works in SQL Playground, aliasing three values as to_field, what am I doing wrong with this question?

    Posted June 12, 2018 3:01am by Michael Martin
    Michael Martin
    3,635 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Deborah Watson
    Deborah Watson
    2,614 Points

    How do I correctly format the email?

    Posted June 10, 2018 6:58pm by Deborah Watson
    Deborah Watson
    2,614 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    2 Answers

  • Odane Williams
    Odane Williams
    5,093 Points

    What "format" do they want the email to be in?

    Posted June 8, 2018 9:22pm by Odane Williams
    Odane Williams
    5,093 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Felix Bynum
    Felix Bynum
    1,084 Points

    It says I need brackets around "email" but email is a column. Please help.

    Posted June 4, 2018 2:30pm by Felix Bynum
    Felix Bynum
    1,084 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

  • Noel Thurau
    Noel Thurau
    530 Points

    I'm having trouble with 2 of the quizzes.

    Posted May 23, 2018 9:57pm by Noel Thurau
    Noel Thurau
    530 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    0 Answers

  • John Tester
    John Tester
    3,366 Points

    SQL Reporting ecommerce challenge; concatenate

    Posted May 14, 2018 2:19pm by John Tester
    John Tester
    3,366 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Concatenating Text

    1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Our mission is to bring affordable technology education to people everywhere in order to help them achieve their dreams and change the world.
Our Company
About Us
Contact Us
Community
Treehouse Stories
Student Perks
Treehouse Blog
Affiliate Program
Careers
Topics
HTML
CSS
Design
JavaScript
Ruby
PHP
WordPress
iOS
Android
Development Tools
Business
Tracks
Web Design
Web Development
Rails Development
PHP Development
iOS Development
Android Development
WordPress Development
Starting a Business
  • Treehouse Blog
  • Shop Treehouse
  • About Treehouse
  • Privacy Policy
  • Terms & Conditions
  • © 2018 Treehouse Island, Inc.

Sign in

I forgot my password