Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

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

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

Jordan young
Courses Plus Student 4,805 Points
1 Answer
Monika Biela
1,183 Points
Bummer messages

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

Monika Biela
1,183 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
devis
4,058 Points
Where are the solutions for the workspace practice sessions of each of the 4 chapters of the course?

Posted August 21, 2020 10:39am by devis

devis
4,058 Points
0 Answers
theteamtreehouse
3,470 Points
I don't get why this is wrong

Posted August 21, 2020 12:24am by theteamtreehouse

theteamtreehouse
3,470 Points
1 Answer
theteamtreehouse
3,470 Points
Why wouldn't this also work?

Posted August 20, 2020 10:55pm by theteamtreehouse

theteamtreehouse
3,470 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,776 Points
Why do we not use 'SELECT FROM' in this query case?

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

Ash Mitchell
4,776 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
aditya verma
1,853 Points
Mistake in code

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

aditya verma
1,853 Points
0 Answers
Todd Hamblen
4,523 Points
What type system is this supposed to be ran on?

Posted July 20, 2020 4:36pm by Todd Hamblen

Todd Hamblen
4,523 Points
1 Answer
sherelle smith
1,387 Points
SELECT * FROM books WHERE genre LIKE "%Fantasy" ORDER BY first_published LIMIT 5 ASC;

Posted July 19, 2020 5:57pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
Alexander Vasin
6,270 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
6,270 Points
1 Answer
PLUS

mohammad almotairy
Courses Plus Student 606 Points
I did not understand the question Write the SQL query to retrieve the 3rd page of results

Posted July 9, 2020 12:23pm by mohammad almotairy

mohammad almotairy
Courses Plus Student 606 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,999 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,999 Points
1 Answer
Matt Fuller
2,395 Points
Is Order Count w/ Date Challenge Still Flawed?

Posted July 3, 2020 5:53pm by Matt Fuller

Matt Fuller
2,395 Points
0 Answers
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,999 Points
should both columns be a substrings?

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

Ariadna Rodriguez
5,999 Points
1 Answer
Ariadna Rodriguez
5,999 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,999 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
stuck

Posted May 27, 2020 3:04pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
NOT understanding

Posted May 26, 2020 6:39pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Derek Morse
1,776 Points
help with details; please break down what i am missing

Posted May 26, 2020 2:30pm by Derek Morse

Derek Morse
1,776 Points
0 Answers
Derek Morse
1,776 Points
STUCK AGAIN

Posted May 26, 2020 2:25pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
STILL STUCK

Posted May 26, 2020 2:21pm by Derek Morse

Derek Morse
1,776 Points
0 Answers

Prev Page 1 of 14 Next

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

Jordan young

Jordan young

Monika Biela

Monika Biela

Tom Weaver

Tom Weaver

devis

devis

theteamtreehouse

theteamtreehouse

theteamtreehouse

theteamtreehouse

theteamtreehouse

theteamtreehouse

Ash Mitchell

Ash Mitchell

Adam Hughes

Adam Hughes

Justin Young

Justin Young

aditya verma

aditya verma

aditya verma

aditya verma

aditya verma

aditya verma

aditya verma

aditya verma

Todd Hamblen

Todd Hamblen

sherelle smith

sherelle smith

Alexander Vasin

Alexander Vasin

mohammad almotairy

mohammad almotairy

Timmy Welch

Timmy Welch

Ariadna Rodriguez

Ariadna Rodriguez

Matt Fuller

Matt Fuller

Tom Holliday

Tom Holliday

Ariadna Rodriguez

Ariadna Rodriguez

Ariadna Rodriguez

Ariadna Rodriguez

Milind Sharma

Milind Sharma

Derek Morse

Derek Morse

Derek Morse

Derek Morse

Derek Morse

Derek Morse

Derek Morse

Derek Morse

Derek Morse

Derek Morse