Treehouse | Community | Concatenating Text

✨ 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! 🚀

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Jennifer Sanders
1,747 Points
Help with code, please.

Posted December 13, 2023 7:39pm by Jennifer Sanders

Jennifer Sanders
1,747 Points
1 Answer
John Munger
Data Analysis Techdegree Graduate 9,736 Points
dead link

Posted December 13, 2023 1:00am by John Munger

John Munger
Data Analysis Techdegree Graduate 9,736 Points
2 Answers
Nameer Jamal
309 Points
Now recreate the MEMBERS table with the new FAVORITE_ROCK_ID column, and make sure it has a foreign key constraint to th

Posted December 11, 2023 9:51am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Nameer Jamal
309 Points
Now, in the MEMBERS table, we'd like to change the FAVORITE_ROCK column to be FAVORITE_ROCK_ID, and it should be a forei

Posted December 11, 2023 9:21am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Nameer Jamal
309 Points
create a table named ROCKS with the following columns: ID, NAME, TYPE, COLOR. And make sure that ID is a primary key.

Posted December 11, 2023 9:01am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Nameer Jamal
309 Points
n the e-commerce database we have a products table. The columns are id, name, description and price. Find all the produ

Posted December 10, 2023 5:05am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Nameer Jamal
309 Points
select first_name as "First Name", last_name as "Last Name", phone as " Phone Number" from phone_book;

Posted November 27, 2023 6:12pm by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Arnold Kim
359 Points
did you select from

Posted November 13, 2023 9:35pm by Arnold Kim

Arnold Kim
359 Points
0 Answers
Wael Elsisi
211 Points
How to use Subqueries ?

Posted November 6, 2023 1:33am by Wael Elsisi

Wael Elsisi
211 Points
1 Answer
Tracy Cano
6,656 Points
Can someone help me understand how to answer this question about outer joins?

Posted October 15, 2023 8:54pm by Tracy Cano

Tracy Cano
6,656 Points
1 Answer
Alex Hort-Francis
12,924 Points
My solution

Posted October 15, 2023 4:40pm by Alex Hort-Francis

Alex Hort-Francis
12,924 Points
0 Answers
Alex Hort-Francis
12,924 Points
On the `DISTINCT` keyword per column in the instructor's example query

Posted October 15, 2023 3:42pm by Alex Hort-Francis

Alex Hort-Francis
12,924 Points
1 Answer
Rojina Pradhan
2,681 Points
Find all the matches in the results table where "Hessle" was playing away as the away team and if they played on or afte

Posted October 3, 2023 2:19pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
2 Answers
Rojina Pradhan
2,681 Points
We're back using the e-commerce database. I only have 10.99 left in my bank account. Write a query that will return all

Posted October 2, 2023 6:05pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
3 Answers
Nataliia Kalinicheva
5,433 Points
I selected 6 columns from 6 and I've got "You didn't select all columns". What should I do?

Posted September 27, 2023 7:54pm by Nataliia Kalinicheva

Nataliia Kalinicheva
5,433 Points
1 Answer
Tremayne Moncrief
2,380 Points
I need help with this question

Posted September 14, 2023 3:14am by Tremayne Moncrief

Tremayne Moncrief
2,380 Points
0 Answers
Rosina Marchan
3,011 Points
There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table

Posted September 7, 2023 6:58pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Rosina Marchan
3,011 Points
What am I missing?

Posted September 7, 2023 6:53pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Rosina Marchan
3,011 Points
Back in the teachers notes I included a reference to how other databases LIMIT results.

Posted September 2, 2023 2:12pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Jason Chalangary
11,695 Points
Bug in the Javascript

Posted August 16, 2023 12:39pm by Jason Chalangary

Jason Chalangary
11,695 Points
1 Answer
Jason Chalangary
11,695 Points
What is wrong with my code?

Posted August 15, 2023 1:21pm by Jason Chalangary

Jason Chalangary
11,695 Points
2 Answers
Juan Moyar
2,871 Points
Result form Task 1

Posted August 4, 2023 3:42pm by Juan Moyar

Juan Moyar
2,871 Points
2 Answers
Uhunoma Osula
6,414 Points
THIS WORKED TOO

Posted July 17, 2023 11:37am by Uhunoma Osula

Uhunoma Osula
6,414 Points
1 Answer
ashwathh
3,129 Points
how to format date in mm/yyyy format in SQL?

Posted June 27, 2023 12:10am by ashwathh

ashwathh
3,129 Points
1 Answer
Jace Vanwagoner
6,767 Points
How can I save the SQL Playground practice's to be able to add them to a portfolio???

Posted May 24, 2023 3:14pm by Jace Vanwagoner

Jace Vanwagoner
6,767 Points
1 Answer
Tyric Foreman
1,398 Points
when youre double checking your work and youre still stuck on a task, how do you get the answer to move along ?

Posted May 11, 2023 10:51am by Tyric Foreman

Tyric Foreman
1,398 Points
- Databases
1 Answer
Sarah E
1,961 Points
Modifying Data with SQL Challenge question

Posted May 10, 2023 2:54pm by Sarah E

Sarah E
1,961 Points
3 Answers
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
Use a subquery along with IN to list all the Model Names with a Sticker Price greater than $30000

Posted May 7, 2023 11:56pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Codi Hasbrouck
41 Points
Date datatype

Posted May 6, 2023 11:26am by Codi Hasbrouck

Codi Hasbrouck
41 Points
- Databases
0 Answers
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
SQL Error: no such column: VIN

Posted May 3, 2023 8:46pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
1 Answer

Prev Page 2 of 389 Next

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