Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Charity Thomas
Front End Web Development Techdegree Student 6,881 Points
Hello. I am stuck on this challenge. Can you please help? Thanks!

Posted February 20, 2021 4:39pm by Charity Thomas

Charity Thomas
Front End Web Development Techdegree Student 6,881 Points
1 Answer
Cherub Chidowe
1,752 Points
Hi, why is this wrong? select title, length(title) AS longest_length from books order by length limit 1;

Posted February 9, 2021 1:55am by Cherub Chidowe

Cherub Chidowe
1,752 Points
1 Answer
Jessie Starborne
3,970 Points
This question doesn't clearly state how it wants longest_length formatted.

Posted January 28, 2021 7:48pm by Jessie Starborne

Jessie Starborne
3,970 Points
1 Answer
Kathuri k
586 Points
syntax looks ok but throwing error

Posted January 25, 2021 8:03pm by Kathuri k

Kathuri k
586 Points
1 Answer
Jack Donaldson
2,846 Points
Unable to complete the objective. Received, "Bummer: Expecting results like L Chalkley' not 'L Chalkley'."

Posted January 23, 2021 9:10am by Jack Donaldson

Jack Donaldson
2,846 Points
1 Answer
Cole Vance
882 Points
How does my query need to be adjusted?

Posted November 22, 2020 10:35pm by Cole Vance

Cole Vance
882 Points
1 Answer
Van Nguyen
1,896 Points
The code was correct but the Bummer expected weirdly.

Posted November 22, 2020 1:36pm by Van Nguyen

Van Nguyen
1,896 Points
0 Answers
Van Nguyen
1,896 Points
Where can I put the angle bracket around the email?

Posted November 20, 2020 4:27pm by Van Nguyen

Van Nguyen
1,896 Points
0 Answers
Mehdi Datoo
2,378 Points
Stuck on this question! Please provide solution!

Posted November 14, 2020 7:40pm by Mehdi Datoo

Mehdi Datoo
2,378 Points
2 Answers
Louis Worth
4,286 Points
Reporting with SQL. Challenge task 1 of 2. am being told that my query didnt return emails in the correct format but why

Posted November 10, 2020 7:40pm by Louis Worth

Louis Worth
4,286 Points
0 Answers
Adam Meikle
6,663 Points
Expected results match actual results yet getting error code, any tips?

Posted November 4, 2020 5:29pm by Adam Meikle

Adam Meikle
6,663 Points
0 Answers
Jenn Giulietti
4,888 Points
CONCAT SQL

Posted November 1, 2020 7:23pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
0 Answers
Jenn Giulietti
4,888 Points
REPLACE SQL

Posted October 30, 2020 8:21pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
Jenn Giulietti
4,888 Points
concatenate SQL

Posted October 30, 2020 7:44pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
2 Answers
Jason Nutt
Front End Web Development Techdegree Graduate 23,497 Points
I really did not want to ask for help on this one as I think I understand the concept...here is the code I tried.

Posted October 26, 2020 4:02pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 23,497 Points
2 Answers
Lyola Rowe
3,803 Points
I'm typing this and getting "incorrect format" error. What am I doing wrong?

Posted October 21, 2020 4:29am by Lyola Rowe

Lyola Rowe
3,803 Points
1 Answer
Pasha Stegall
Front End Web Development Techdegree Student 1,220 Points
Challenge Task 1 of 2 - Can't get beyond it, What have I done wrong??

Posted October 12, 2020 11:24pm by Pasha Stegall

Pasha Stegall
Front End Web Development Techdegree Student 1,220 Points
2 Answers
John Richter
2,351 Points
how to replace a single piece of a randomly placed character in a substring.

Posted October 12, 2020 2:42pm by John Richter

John Richter
2,351 Points
2 Answers
Talon Ward
2,417 Points
SELECT REPLACE(email, "@" "<at>") AS "obfuscated_email" FROM customers; What am I missing here?

Posted October 9, 2020 12:00am by Talon Ward

Talon Ward
2,417 Points
1 Answer
PLUS

Jordan young
Courses Plus Student 5,250 Points
Alias in Concatenation Reporting

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

Jordan young
Courses Plus Student 5,250 Points
1 Answer
Monika Biela
3,370 Points
Bummer messages

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

Monika Biela
3,370 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
5,416 Points
Why do we not use 'SELECT FROM' in this query case?

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

Ash Mitchell
5,416 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
7,938 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
7,938 Points
1 Answer

Prev Page 1 of 8 Next

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