Treehouse | Community | Concatenating Text

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

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

🌟 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
All Topics

Karen Shumate
13,579 Points
Concatenate the street, city, state, zip and country in the following format. Street, City, State Zip. Country e.g. 34 N

Posted September 29, 2018 2:39pm by Karen Shumate

Karen Shumate
13,579 Points
0 Answers
tonderayi masiyandima
5,673 Points
Challenge Task 1 of 1 We're in a movie database.

Posted September 29, 2018 1:21pm by tonderayi masiyandima

tonderayi masiyandima
5,673 Points
2 Answers
Ceil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 Points
How to make a database?

Posted September 29, 2018 6:47am by Ceil-Ian Maralit

Ceil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 Points
- Databases
2 Answers
Karen Shumate
13,579 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_publishedcolumn.

Posted September 29, 2018 1:35am by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Damian Toczek
4,471 Points
How should i count it then?

Posted September 29, 2018 12:38am by Damian Toczek

Damian Toczek
4,471 Points
1 Answer
Fairooz Adams
2,704 Points
Problem with code.

Posted September 28, 2018 9:22pm by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
Ali Dabbir Khan
1,076 Points
What is the correct answer to the 2nd question?

Posted September 28, 2018 8:21am by Ali Dabbir Khan

Ali Dabbir Khan
1,076 Points
1 Answer
Harshay Raipancholi
Python Development Techdegree Student 11,521 Points
load() doesn't work on windows

Posted September 27, 2018 1:32pm by Harshay Raipancholi

Harshay Raipancholi
Python Development Techdegree Student 11,521 Points
1 Answer
Kolio Kolev
785 Points
Not sure what's going on, but it keeps saying "did you select from the results table" and my code clearly selects it

Posted September 27, 2018 1:12am by Kolio Kolev

Kolio Kolev
785 Points
0 Answers
Sassafras Finley
13,168 Points
I have no idea why this isn't returning the right amount of rows. Please tell me what I've got wrong here.

Posted September 26, 2018 4:22pm by Sassafras Finley

Sassafras Finley
13,168 Points
1 Answer
mulgey
9,899 Points
Real difficulties on Windows 10

Posted September 26, 2018 12:23pm by mulgey

mulgey
9,899 Points
1 Answer
Damian Toczek
4,471 Points
I found a "mistake"?

Posted September 25, 2018 7:27pm by Damian Toczek

Damian Toczek
4,471 Points
1 Answer
jack cunniff
1,248 Points
I cant install MySQL because my computer is too old for mac os 10.10

Posted September 25, 2018 4:29pm by jack cunniff

jack cunniff
1,248 Points
- Databases
1 Answer
Jonathon Hyland
5,016 Points
SQL Query Error

Posted September 25, 2018 9:35am by Jonathon Hyland

Jonathon Hyland
5,016 Points
- Databases
- Migrating the Database
0 Answers
Sonia Cabon
1,173 Points
bummer: you're missing the where cause

Posted September 24, 2018 9:47am by Sonia Cabon

Sonia Cabon
1,173 Points
3 Answers
rsa14
1,865 Points
My two inner joins won't work?

Posted September 21, 2018 9:14pm by rsa14

rsa14
1,865 Points
1 Answer
PLUS

Ciaran Wood
Courses Plus Student 6,787 Points
sql playground disappears

Posted September 21, 2018 8:33am by Ciaran Wood

Ciaran Wood
Courses Plus Student 6,787 Points
0 Answers
elomaur
5,276 Points
How can I show all periods without using a CTE?

Posted September 21, 2018 3:05am by elomaur

elomaur
5,276 Points
3 Answers
Kevin May
1,435 Points
When asked "Write a query to count all the unique genres in the books table. Alias it as total_genres." get wrong count?

Posted September 19, 2018 2:04pm by Kevin May

Kevin May
1,435 Points
2 Answers
Nadia Logan
3,747 Points
It wont work

Posted September 18, 2018 9:31am by Nadia Logan

Nadia Logan
3,747 Points
1 Answer
Sean McLeskey
2,033 Points
Why am I seeing an "ambiguous column name" error when I'm trying to join tables if the column name is spelled correctly?

Posted September 17, 2018 10:32pm by Sean McLeskey

Sean McLeskey
2,033 Points
2 Answers
Courage Tafadzwa Chesa
5,308 Points
Does this code work lol im now stuck

Posted September 17, 2018 1:29pm by Courage Tafadzwa Chesa

Courage Tafadzwa Chesa
5,308 Points
1 Answer
Kevin Matter
2,507 Points
Question Bug

Posted September 16, 2018 3:26pm by Kevin Matter

Kevin Matter
2,507 Points
2 Answers
Gurdeep singh
1,522 Points
CAN WE USE JOINS IN SUBQUERY?

Posted September 16, 2018 2:43pm by Gurdeep singh

Gurdeep singh
1,522 Points
- Databases
1 Answer
kevin nadjarian
1,498 Points
COUNT(*) result change

Posted September 16, 2018 11:48am by kevin nadjarian

kevin nadjarian
1,498 Points
- Databases
1 Answer
Gurdeep singh
1,522 Points
NEED HELP SQL SUBQUERY IT'S difficult

Posted September 16, 2018 9:04am by Gurdeep singh

Gurdeep singh
1,522 Points
- Databases
1 Answer
Robert Edwardes
15,777 Points
Using union all and not getting correct result

Posted September 15, 2018 10:28pm by Robert Edwardes

Robert Edwardes
15,777 Points
1 Answer
kevin nadjarian
1,498 Points
LIKE "%x"

Posted September 15, 2018 7:18pm by kevin nadjarian

kevin nadjarian
1,498 Points
1 Answer
kevin nadjarian
1,498 Points
Select Multiple table VS INNER JOIN?

Posted September 15, 2018 6:08pm by kevin nadjarian

kevin nadjarian
1,498 Points
2 Answers
Nomore Majuru
7,881 Points
database

Posted September 14, 2018 7:15am by Nomore Majuru

Nomore Majuru
7,881 Points
- Databases
1 Answer

Prev Page 34 of 389 Next

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