Treehouse | Community | Concatenating Text

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Namazbek Bekarysuly
882 Points
SELECT first_name || " " || last_name " " || "<" || email || ">" AS "to_field" FROM patrons;

Posted February 22, 2019 11:14pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
2 Answers
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Query producing incorrect results

Posted February 20, 2019 7:55pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
2 Answers
Christian Schou
9,208 Points
Error in SQL challenge

Posted February 19, 2019 9:49am by Christian Schou

Christian Schou
9,208 Points
1 Answer
dfeem
4,660 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
4,660 Points
2 Answers
Hans Eisenman
1,315 Points
How do you build a Where clause that selects out all words which start with letters A-K?

Posted February 14, 2019 2:47pm by Hans Eisenman

Hans Eisenman
1,315 Points
4 Answers
Dan Epstein
3,233 Points
Can anyone assist with how to order the statement in the first SQL Concatenation code challenge? I kind of got lost.

Posted February 14, 2019 10:07am by Dan Epstein

Dan Epstein
3,233 Points
6 Answers
Harris Handoko
3,932 Points
Why is the WHERE clause required here instead of the HAVING clause?

Posted February 1, 2019 2:24am by Harris Handoko

Harris Handoko
3,932 Points
1 Answer
vishal mishra
387 Points
select CONCAT(first_name , " " ,last_name , " " ,email)AS "to_field" from patrons what is wrong in it

Posted January 26, 2019 2:38pm by vishal mishra

vishal mishra
387 Points
1 Answer
Jeremy Jones
886 Points
Challenge Task 1 of 3 from the SQL Deletions lesson not working

Posted January 18, 2019 10:52pm by Jeremy Jones

Jeremy Jones
886 Points
1 Answer
Mark Chesney
11,747 Points
SQL self join

Posted January 13, 2019 8:50pm by Mark Chesney

Mark Chesney
11,747 Points
2 Answers
George May
3,324 Points
Answers to Review and Practice

Posted December 31, 2018 10:46am by George May

George May
3,324 Points
3 Answers
Leslie Perez
993 Points
Don't understand why I get an error

Posted December 30, 2018 1:46am by Leslie Perez

Leslie Perez
993 Points
1 Answer
Susan Tan
381 Points
my answer does not work

Posted December 27, 2018 11:44pm by Susan Tan

Susan Tan
381 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
error

Posted December 24, 2018 4:30pm by YA Abidakadr

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
David Corrales
4,698 Points
Oh my gosh this stuff is getting tough! Subqueries are challenging anyone know how to solve this?

Posted December 19, 2018 11:26pm by David Corrales

David Corrales
4,698 Points
4 Answers
David Corrales
4,698 Points
Hi Community! Sorry to be a bother! =[ This challenge is stumping me!

Posted December 17, 2018 12:38am by David Corrales

David Corrales
4,698 Points
1 Answer
Otec Perez Glass
7,678 Points
Is not Working!

Posted December 17, 2018 12:38am by Otec Perez Glass

Otec Perez Glass
7,678 Points
3 Answers
David Corrales
4,698 Points
Some small minor error perhaps reporting with SQL, can someone help?

Posted December 16, 2018 9:06pm by David Corrales

David Corrales
4,698 Points
3 Answers
kekai borah
855 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted December 7, 2018 6:15am by kekai borah

kekai borah
855 Points
2 Answers
Dilip Kalidindi
1,042 Points
SQL Help

Posted December 5, 2018 3:51am by Dilip Kalidindi

Dilip Kalidindi
1,042 Points
3 Answers
okilydokily
12,105 Points
I'm not seeing the difference?

Posted December 3, 2018 4:49am by okilydokily

okilydokily
12,105 Points
2 Answers
Hugh Kelly
278 Points
What is the mySQL keyword/command for "loading" a schema?

Posted November 14, 2018 1:19pm by Hugh Kelly

Hugh Kelly
278 Points
- Databases
2 Answers
Shahrukh Azhar Khan
2,135 Points
I am having problems writing the code for this challenge. Can someone please help me! Thanks

Posted November 12, 2018 11:06pm by Shahrukh Azhar Khan

Shahrukh Azhar Khan
2,135 Points
2 Answers
Foster Lartey
927 Points
How do I concatenate into this exact format - Andrew Chalkley <andrew@teamtreehouse.com>?

Posted November 10, 2018 4:31am by Foster Lartey

Foster Lartey
927 Points
2 Answers
Siraj Khan
3,451 Points
Can anyone please help me with this challenge.?

Posted November 9, 2018 1:13pm by Siraj Khan

Siraj Khan
3,451 Points
1 Answer
jlampstack
23,932 Points
Is my solution correct?

Posted June 29, 2018 12:52pm by jlampstack

jlampstack
23,932 Points
2 Answers
Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
Yeah, Wii U's didn't sell that well...

Posted February 16, 2018 7:41pm by Neil Bircumshaw

Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
4 Answers
Bruce McMinn
10,030 Points
A different approach and learning about JOIN

Posted August 7, 2017 8:10pm by Bruce McMinn

Bruce McMinn
10,030 Points
4 Answers
George Athanasia
5,750 Points
WHAT AM I MISSING

Posted September 20, 2016 8:17am by George Athanasia

George Athanasia
5,750 Points
- Databases
16 Answers
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
How do we know what date the order was shipped on?

Posted March 1, 2016 12:19am by Brendan Whiting

Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
- Databases
13 Answers

Prev Page 183 of 389 Next

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