Treehouse | Community | Concatenating Text

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

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

Take our "AI in Tech Jobs" survey and win 3 months free Treehouse!

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

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
• Databases

Daiana Cherhynets
1,354 Points
SELECT ||(first_name, ' ', last_name, ' <', email, '>') AS to_field FROM patrons

Posted on Apr 30, 2023 by Daiana Cherhynets

Daiana Cherhynets
1,354 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
Hello, Please help me, what wrong with my command?

Posted on Apr 29, 2023 by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
I don't understand where is the mistake? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted on Apr 26, 2023 by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
IN a library database....

Posted on Apr 24, 2023 by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Alyssa Daniel
1,944 Points
I don't understand

Posted on Apr 20, 2023 by Alyssa Daniel

Alyssa Daniel
1,944 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
What does this error mean: Bummer: Was expecting 7 entries in the phone_book table. There's only 6.

Posted on Apr 17, 2023 by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
7 Answers
Anakin Bjelland
7,176 Points
I need some help with this union challenge

Posted on Mar 30, 2023 by Anakin Bjelland

Anakin Bjelland
7,176 Points
1 Answer
Eric Agbayani
Full Stack JavaScript Techdegree Graduate 15,011 Points
Adding a new product, but my command is not working.

Posted on Mar 24, 2023 by Eric Agbayani

Eric Agbayani
Full Stack JavaScript Techdegree Graduate 15,011 Points
1 Answer
Wufei Hong
1,393 Points
bummer reason

Posted on Mar 24, 2023 by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Fidelis Chime
6,077 Points
inserting data on the database row

Posted on Mar 20, 2023 by Fidelis Chime

Fidelis Chime
6,077 Points
1 Answer
Fidelis Chime
6,077 Points
ADD FOREIGN KEY

Posted on Mar 13, 2023 by Fidelis Chime

Fidelis Chime
6,077 Points
1 Answer
Krithika Pirahalathan
150 Points
alias the query

Posted on Mar 8, 2023 by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
1 Answer
Krithika Pirahalathan
150 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted on Mar 8, 2023 by Krithika Pirahalathan

Krithika Pirahalathan
150 Points
0 Answers
Danielle Petrides
5,346 Points
REPLACE() with string literal and single quotes?

Posted on Mar 8, 2023 by Danielle Petrides

Danielle Petrides
5,346 Points
- Databases
1 Answer
Wufei Hong
1,393 Points
don't know what's wrong wiz my code

Posted on Mar 4, 2023 by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Alberto Gurrola
1,769 Points
Hi, I'm not too sure what I'm doing wrong. I tried entering this code but it's still wrong.

Posted on Feb 22, 2023 by Alberto Gurrola

Alberto Gurrola
1,769 Points
1 Answer
Vincent Almeroth
12,123 Points
What lesson shows use how to filter by the first letter of a column value?

Posted on Feb 22, 2023 by Vincent Almeroth

Vincent Almeroth
12,123 Points
1 Answer
Andy McDonald
Python Development Techdegree Graduate 13,801 Points
Expecting an extra value when not defining columns first

Posted on Feb 13, 2023 by Andy McDonald

Andy McDonald
Python Development Techdegree Graduate 13,801 Points
1 Answer
Joel Fuster
2,429 Points
Are you able to review my script? It returns incorrect but I can't seem to figure out why

Posted on Feb 12, 2023 by Joel Fuster

Joel Fuster
2,429 Points
1 Answer
Minh Duong
1,616 Points
SELECT CONCAT(first_name, ' ', last_name) AS "To_field", CONCAT('<', email, '>') AS "To" FROM patrons; why is missing?

Posted on Feb 9, 2023 by Minh Duong

Minh Duong
1,616 Points
1 Answer
Kenzie Iles
1,773 Points
Error: near "ID": syntax error

Posted on Feb 6, 2023 by Kenzie Iles

Kenzie Iles
1,773 Points
1 Answer
Vernon Kincaid
11,447 Points
What is a where statement that will not return a row that starts with the letter L through Z

Posted on Jan 29, 2023 by Vernon Kincaid

Vernon Kincaid
11,447 Points
1 Answer
Brian Taylor
3,436 Points
Your code challenge appears to have a broken Javascript file in it? (or at least in this instance of the virtual machine

Posted on Jan 26, 2023 by Brian Taylor

Brian Taylor
3,436 Points
1 Answer
Sam Speaks
6,013 Points
What is this supposedly outputting? (Subqueries)

Posted on Jan 25, 2023 by Sam Speaks

Sam Speaks
6,013 Points
1 Answer
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Car data base query

Posted on Jan 24, 2023 by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Querying Relational Database error

Posted on Jan 21, 2023 by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
1 Answer
Viktorija Kalniņa
1,652 Points
Error in script

Posted on Jan 17, 2023 by Viktorija Kalniņa

Viktorija Kalniņa
1,652 Points
2 Answers
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Import Table in my VS code

Posted on Jan 13, 2023 by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Alexei Lazarowicz
5,153 Points
I have no idea how to sort the names by what letter they start with

Posted on Jan 11, 2023 by Alexei Lazarowicz

Alexei Lazarowicz
5,153 Points
1 Answer
Miroslav Pasajlic
795 Points
Question Expecting results like 'L Chalkley' not 'L Chalkley'

Posted on Dec 23, 2022 by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
2 Answers

Prev Page 3 of 389 Next

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