Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Robert Hecht
5,883 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

Posted March 20, 2019 2:54pm by Robert Hecht

Robert Hecht
5,883 Points
1 Answer
David Wells
12,830 Points
In the second question of the library/full name question, how do I write the concatenation SQL statement?

Posted March 19, 2019 5:54pm by David Wells

David Wells
12,830 Points
2 Answers
Ker Sing Tan
6,664 Points
solve missing where cause error

Posted March 17, 2019 7:42am by Ker Sing Tan

Ker Sing Tan
6,664 Points
1 Answer
sulaiman abouabdah
Python Web Development Techdegree Student 4,658 Points
Error when inserting my own table on my command line message ERROR 1064 (42000): You have an error in your SQL syntax;

Posted March 12, 2019 9:15pm by sulaiman abouabdah

sulaiman abouabdah
Python Web Development Techdegree Student 4,658 Points
1 Answer
Shahrukh Siddiqui
2,698 Points
UNABLE TO WRITE THE QUERY

Posted March 6, 2019 5:51am by Shahrukh Siddiqui

Shahrukh Siddiqui
2,698 Points
1 Answer
Satyam garhewal
326 Points
Why my query is not working, can you please help me out?

Posted March 1, 2019 5:46am by Satyam garhewal

Satyam garhewal
326 Points
2 Answers
Øystein Kallset
637 Points
What is wrong with this SQL-statement: SELECT REPLACE(email,"@","<at>") FROM customers

Posted February 28, 2019 7:43am by Øystein Kallset

Øystein Kallset
637 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 4:03pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 12:59am by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
Namazbek Bekarysuly
882 Points
SELECT first_name || " " || last_name " " || "<" || email || ">" AS "to_field" FROM patrons;

Posted February 22, 2019 11:14pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
2 Answers
dfeem
3,818 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
3,818 Points
2 Answers
Dan Epstein
2,794 Points
Can anyone assist with how to order the statement in the first SQL Concatenation code challenge? I kind of got lost.

Posted February 14, 2019 10:07am by Dan Epstein

Dan Epstein
2,794 Points
6 Answers
william gallagher
1,919 Points
What is wrong with my code?

Posted February 11, 2019 1:43am by william gallagher

william gallagher
1,919 Points
1 Answer
Dinesh Dewnarain
1,089 Points
Limit rows

Posted February 10, 2019 4:12pm by Dinesh Dewnarain

Dinesh Dewnarain
1,089 Points
1 Answer
Iman Ali
3,443 Points
ERROR WHEN CONCATENATING WITH A COMMA

Posted February 10, 2019 1:46pm by Iman Ali

Iman Ali
3,443 Points
2 Answers
Andrzej Szelemetko
25,447 Points
replace(email, '@', '<at>') problems in task I am getting the following error: Bummer: Expectin

Posted February 3, 2019 7:31pm by Andrzej Szelemetko

Andrzej Szelemetko
25,447 Points
1 Answer
Harris Handoko
3,386 Points
Why is the WHERE clause required here instead of the HAVING clause?

Posted February 1, 2019 2:24am by Harris Handoko

Harris Handoko
3,386 Points
1 Answer
Michael Nanni
3,760 Points
What exactly am I counting?

Posted January 29, 2019 1:29pm by Michael Nanni

Michael Nanni
3,760 Points
0 Answers
Jeremy Jones
885 Points
Unclear what the desired answer is, again

Posted January 28, 2019 8:44pm by Jeremy Jones

Jeremy Jones
885 Points
1 Answer
vishal mishra
387 Points
select CONCAT(first_name , " " ,last_name , " " ,email)AS "to_field" from patrons what is wrong in it

Posted January 26, 2019 2:38pm by vishal mishra

vishal mishra
387 Points
1 Answer
Jeremy Jones
885 Points
Unclear what I am getting wrong...

Posted January 24, 2019 5:19pm by Jeremy Jones

Jeremy Jones
885 Points
2 Answers
Nerijus Velavicius
249 Points
SELECT Street || ", " || " " || City || ", " || " " || State || " " || Zip || "." || " " || Country || " " AS address

Posted January 23, 2019 7:10pm by Nerijus Velavicius

Nerijus Velavicius
249 Points
1 Answer
dfeem
3,818 Points
Stuck on this task?

Posted January 22, 2019 12:38am by dfeem

dfeem
3,818 Points
2 Answers
Richard Külling
7,493 Points
I don't see what's wrong with my query, it seems that it returns what is asked for, doesn't it?

Posted January 19, 2019 6:35pm by Richard Külling

Richard Külling
7,493 Points
1 Answer
Thomas Wilson
17,758 Points
I keep getting the wrong sum but I don't know what I'm doing wrong.

Posted January 17, 2019 2:53pm by Thomas Wilson

Thomas Wilson
17,758 Points
0 Answers
Mark Chesney
10,821 Points
february 31

Posted January 12, 2019 5:20am by Mark Chesney

Mark Chesney
10,821 Points
0 Answers
Mark Chesney
10,821 Points
link in GitHub not working; please help

Posted January 11, 2019 12:34am by Mark Chesney

Mark Chesney
10,821 Points
0 Answers
Thomas Dam
5,237 Points
Having trouble with Task 2 of Challenge

Posted January 9, 2019 2:31pm by Thomas Dam

Thomas Dam
5,237 Points
1 Answer
Alejandro Carvajal
6,772 Points
Question not written correctly

Posted January 8, 2019 6:45pm by Alejandro Carvajal

Alejandro Carvajal
6,772 Points
1 Answer
Alejandro Carvajal
6,772 Points
Why would a WHERE clause be necessary if I could just return the asked-for information by just ordering with ORDER BY???

Posted January 8, 2019 6:33pm by Alejandro Carvajal

Alejandro Carvajal
6,772 Points
1 Answer

Prev Page 1 of 9 Next

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