Treehouse | Community | Concatenating Text

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

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Nerijus Velavicius
249 Points
SELECT Street || ", " || " " || City || ", " || " " || State || " " || Zip || "." || " " || Country || " " AS address

Posted January 23, 2019 7:10pm by Nerijus Velavicius

Nerijus Velavicius
249 Points
1 Answer
Mark Chesney
11,747 Points
smelly issue: query came close

Posted January 23, 2019 5:14am by Mark Chesney

Mark Chesney
11,747 Points
2 Answers
Gia Hoang Nguyen
4,137 Points
Select * from Fruit Union Select * from Vegetable; I cant pass the challenge that asks to Create a distinct result"

Posted January 23, 2019 4:52am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer
dfeem
4,660 Points
Stuck on this task?

Posted January 22, 2019 12:38am by dfeem

dfeem
4,660 Points
2 Answers
Richard Külling
9,465 Points
How does this query not give the correct results?

Posted January 21, 2019 12:32am by Richard Külling

Richard Külling
9,465 Points
1 Answer
Richard Külling
9,465 Points
I don't see what's wrong with my query, it seems that it returns what is asked for, doesn't it?

Posted January 19, 2019 6:35pm by Richard Külling

Richard Külling
9,465 Points
1 Answer
Arthur Dunn
2,094 Points
Can I get help with Question 4: Derived Tables?

Posted January 18, 2019 11:49pm by Arthur Dunn

Arthur Dunn
2,094 Points
1 Answer
Mark Chesney
11,747 Points
SQL workspaces: Is there a RUN shortcut key?

Posted January 18, 2019 11:40pm by Mark Chesney

Mark Chesney
11,747 Points
- Databases
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
Max Green
12,517 Points
REFERENCES and foreign keys syntax.

Posted January 18, 2019 4:17am by Max Green

Max Green
12,517 Points
1 Answer
Thomas Wilson
18,741 Points
I keep getting the wrong sum but I don't know what I'm doing wrong.

Posted January 17, 2019 2:53pm by Thomas Wilson

Thomas Wilson
18,741 Points
1 Answer
Bruno Paris
3,568 Points
I think this is not working

Posted January 15, 2019 1:44am by Bruno Paris

Bruno Paris
3,568 Points
0 Answers
Mark Chesney
11,747 Points
SQL self join

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

Mark Chesney
11,747 Points
2 Answers
Seamus Sionóid
27,798 Points
NOT BETWEEN ?

Posted January 13, 2019 1:11pm by Seamus Sionóid

Seamus Sionóid
27,798 Points
0 Answers
Tevin Muparadzi
1,724 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted January 13, 2019 4:22am by Tevin Muparadzi

Tevin Muparadzi
1,724 Points
1 Answer
Mark Chesney
11,747 Points
february 31

Posted January 12, 2019 5:20am by Mark Chesney

Mark Chesney
11,747 Points
1 Answer
Ali Imran
4,311 Points
Help please

Posted January 12, 2019 4:47am by Ali Imran

Ali Imran
4,311 Points
1 Answer
Mark Chesney
11,747 Points
link in GitHub not working; please help

Posted January 11, 2019 12:34am by Mark Chesney

Mark Chesney
11,747 Points
1 Answer
Kevin Gates
15,053 Points
Anyone know of an up-to-date course for Stored Procedures and MS SQL?

Posted January 10, 2019 5:54pm by Kevin Gates

Kevin Gates
15,053 Points
- Databases
1 Answer
Mishu Jahur
5,238 Points
How can "GROUP BY" act on non-column values?

Posted January 10, 2019 2:22am by Mishu Jahur

Mishu Jahur
5,238 Points
1 Answer
Thomas Dam
5,237 Points
Having trouble with Task 2 of Challenge

Posted January 9, 2019 2:31pm by Thomas Dam

Thomas Dam
5,237 Points
1 Answer
Alvand Hajizadeh
2,069 Points
Can't get question 2 for set questions.

Posted January 9, 2019 2:28am by Alvand Hajizadeh

Alvand Hajizadeh
2,069 Points
2 Answers
Hans Eisenman
1,315 Points
Having trouble with a Join challenge. Syntax Error

Posted January 8, 2019 10:00pm by Hans Eisenman

Hans Eisenman
1,315 Points
- Databases
2 Answers
Mishu Jahur
5,238 Points
I'm stuck on an exercise regarding the ORDER key word and LIMIT keyword, but the exercise is telling me to use WHERE

Posted January 8, 2019 8:13pm by Mishu Jahur

Mishu Jahur
5,238 Points
- Databases
1 Answer
Alejandro Carvajal
9,100 Points
Question not written correctly

Posted January 8, 2019 6:45pm by Alejandro Carvajal

Alejandro Carvajal
9,100 Points
1 Answer
Alejandro Carvajal
9,100 Points
Why would a WHERE clause be necessary if I could just return the asked-for information by just ordering with ORDER BY???

Posted January 8, 2019 6:33pm by Alejandro Carvajal

Alejandro Carvajal
9,100 Points
1 Answer
Kevin Gates
15,053 Points
So if you have a date + time, and you add a year, won't the result be a date + time? I thought you had to use STRFTIME?

Posted January 7, 2019 4:53pm by Kevin Gates

Kevin Gates
15,053 Points
1 Answer
Grafton John
2,184 Points
Concatenation code challange

Posted January 2, 2019 6:21am by Grafton John

Grafton John
2,184 Points
2 Answers
Bennett Lappen
12,035 Points
How do I know which table to make 'Inner'?

Posted January 1, 2019 5:23pm by Bennett Lappen

Bennett Lappen
12,035 Points
1 Answer
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

Prev Page 28 of 388 Next

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