Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

Jordan young
Courses Plus Student 4,108 Points
Alias in Concatenation Reporting

Posted September 16, 2020 3:05am by Jordan young

Jordan young
Courses Plus Student 4,108 Points
1 Answer
Monika Biela
862 Points
Bummer messages

Posted September 10, 2020 12:24pm by Monika Biela

Monika Biela
862 Points
1 Answer
Tom Weaver
2,342 Points
I can't get my head around the aliasing here.

Posted September 3, 2020 3:13pm by Tom Weaver

Tom Weaver
2,342 Points
1 Answer
theteamtreehouse
3,470 Points
This test case only supports "operator ||", but it did not specify that it only supports SQLite syntax. I used CONCAT().

Posted August 20, 2020 4:15pm by theteamtreehouse

theteamtreehouse
3,470 Points
0 Answers
Ash Mitchell
4,547 Points
Why do we not use 'SELECT FROM' in this query case?

Posted August 13, 2020 12:31pm by Ash Mitchell

Ash Mitchell
4,547 Points
1 Answer
Adam Hughes
1,259 Points
Getting Max Length with title

Posted August 11, 2020 1:28pm by Adam Hughes

Adam Hughes
1,259 Points
1 Answer
Justin Young
7,015 Points
SELECT first_name || " " || last_name || " " || <email> AS "to_field" FROM patrons; [SOLVED]

Posted August 4, 2020 9:20pm by Justin Young

Justin Young
7,015 Points
0 Answers
aditya verma
1,853 Points
Please improve the quality of questions, the period at the end of the text, is it part of the output or not?!

Posted August 2, 2020 11:06am by aditya verma

aditya verma
1,853 Points
2 Answers
aditya verma
1,853 Points
Don't know whats wrong

Posted August 2, 2020 10:58am by aditya verma

aditya verma
1,853 Points
1 Answer
aditya verma
1,853 Points
Cannot identify the mistake

Posted August 2, 2020 10:55am by aditya verma

aditya verma
1,853 Points
0 Answers
Alexander Vasin
5,979 Points
Bummer: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001". Looks like the same

Posted July 17, 2020 4:53pm by Alexander Vasin

Alexander Vasin
5,979 Points
1 Answer
Timmy Welch
1,592 Points
Getting same result as expected but not being allowed past the question.

Posted July 4, 2020 3:27pm by Timmy Welch

Timmy Welch
1,592 Points
1 Answer
Ariadna Rodriguez
5,995 Points
I don't understand where I should SELECT a new column and where I should concatenate the new output

Posted July 4, 2020 9:39am by Ariadna Rodriguez

Ariadna Rodriguez
5,995 Points
1 Answer
Tom Holliday
2,718 Points
I don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?

Posted July 1, 2020 1:36pm by Tom Holliday

Tom Holliday
2,718 Points
1 Answer
Ariadna Rodriguez
5,995 Points
should both columns be a substrings?

Posted July 1, 2020 4:14am by Ariadna Rodriguez

Ariadna Rodriguez
5,995 Points
1 Answer
Ariadna Rodriguez
5,995 Points
Should I be adding a space in between the commas also is that why my query is incorrect?

Posted June 29, 2020 1:03am by Ariadna Rodriguez

Ariadna Rodriguez
5,995 Points
0 Answers
Milind Sharma
2,656 Points
Why am i getting extra . at the end the select statement?

Posted June 17, 2020 4:40pm by Milind Sharma

Milind Sharma
2,656 Points
1 Answer
Derek Morse
1,776 Points
What am i missing

Posted May 15, 2020 5:03pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Derek Morse
1,776 Points
What am I missing

Posted May 15, 2020 4:14pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Gathoni Alice
803 Points
concatenate and change case of the same string

Posted May 4, 2020 12:48pm by Gathoni Alice

Gathoni Alice
803 Points
0 Answers
bright chibuike
3,245 Points
changing cases of a string

Posted April 26, 2020 11:46am by bright chibuike

bright chibuike
3,245 Points
2 Answers
Aquoinette Blair
922 Points
Bummer Error

Posted April 24, 2020 7:50pm by Aquoinette Blair

Aquoinette Blair
922 Points
1 Answer
Jay Narain
2,311 Points
In the SQL playground there is the assignment "review attribution". but we do not know how to change the column order?

Posted April 24, 2020 4:58pm by Jay Narain

Jay Narain
2,311 Points
2 Answers
Stacy Villibord
2,017 Points
Correct my syntax

Posted April 24, 2020 12:16am by Stacy Villibord

Stacy Villibord
2,017 Points
1 Answer
Samantha York
703 Points
I cannot figure out the solution to Challenge Task 1 of 2 under Reporting with SQL: Adding Text Columns Together

Posted April 23, 2020 11:10pm by Samantha York

Samantha York
703 Points
1 Answer
Taylor Han
2,405 Points
Concatenation with an alias

Posted April 16, 2020 11:47pm by Taylor Han

Taylor Han
2,405 Points
1 Answer
Taylor Han
2,405 Points
REPLACE function with SQL

Posted April 15, 2020 8:39pm by Taylor Han

Taylor Han
2,405 Points
1 Answer
Taylor Han
2,405 Points
Casing strings with SQL

Posted April 15, 2020 7:58pm by Taylor Han

Taylor Han
2,405 Points
1 Answer
Taylor Han
2,405 Points
Length reporting with SQL

Posted April 15, 2020 7:49pm by Taylor Han

Taylor Han
2,405 Points
1 Answer
vona goodpaster
1,405 Points
need help

Posted April 15, 2020 1:54am by vona goodpaster

vona goodpaster
1,405 Points
2 Answers

Prev Page 1 of 7 Next

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