Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Luke Otto
1,109 Points
STRFTIME Question Issue

Posted July 7, 2019 10:44pm by Luke Otto

Luke Otto
1,109 Points
1 Answer
Christopher Endswell
1,781 Points
Getting the following error message: Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'. What is going on?

Posted June 22, 2019 8:45am by Christopher Endswell

Christopher Endswell
1,781 Points
2 Answers
omid ayoobe
5,274 Points
get same results but error in code. SUBSTR(first_name,1,1)

Posted June 20, 2019 5:12pm by omid ayoobe

omid ayoobe
5,274 Points
1 Answer
Adam Tyler
4,922 Points
Why does this need a WHERE clause?

Posted June 19, 2019 4:02pm by Adam Tyler

Adam Tyler
4,922 Points
1 Answer
Shikhar Prateek
1,778 Points
'Your query didn't retrieve the emails in the correct format.' But the query is giving the same result in the workspace.

Posted June 14, 2019 12:23pm by Shikhar Prateek

Shikhar Prateek
1,778 Points
1 Answer
brayden gosse
750 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted May 21, 2019 3:10am by brayden gosse

brayden gosse
750 Points
2 Answers
Hugo Macfarland
2,030 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted May 19, 2019 4:48pm by Hugo Macfarland

Hugo Macfarland
2,030 Points
1 Answer
Felix Belga
2,391 Points
I cannot see what is wrong with my code

Posted May 16, 2019 6:55pm by Felix Belga

Felix Belga
2,391 Points
3 Answers
Faisal Aleissa
1,677 Points
why id did not work

Posted April 27, 2019 11:14pm by Faisal Aleissa

Faisal Aleissa
1,677 Points
0 Answers
Nelson Pamplona
1,575 Points
I am not sure if I am supposed to include anything but first name, last name and email for this challenge.

Posted April 23, 2019 8:08pm by Nelson Pamplona

Nelson Pamplona
1,575 Points
3 Answers
Grady Robbins
8,249 Points
Reporting with SQL final assesment: i am thrown off by: LIMIT 0, OFFSET 50. should any rows be returned at all?

Posted April 21, 2019 5:23pm by Grady Robbins

Grady Robbins
8,249 Points
2 Answers
sofia Heikkila Svensson
3,390 Points
Hi, My code is wrong. The bummer answer is : You should try writing a SELECT query.

Posted April 18, 2019 7:33am by sofia Heikkila Svensson

sofia Heikkila Svensson
3,390 Points
1 Answer
Karl Hogben
462 Points
> SELECT * FROM books WHERE genre = "Fantasy" ORDER BY genre ASC LIMIT 5

Posted April 14, 2019 4:33pm by Karl Hogben

Karl Hogben
462 Points
1 Answer
sj sh
122 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted April 11, 2019 8:37am by sj sh

sj sh
122 Points
0 Answers
Marat Guysin
1,601 Points
Cannot get the right SQL statement

Posted April 6, 2019 11:28pm by Marat Guysin

Marat Guysin
1,601 Points
1 Answer
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers
taherkhan
4,327 Points
Query regarding calculating average

Posted March 24, 2019 9:46am by taherkhan

taherkhan
4,327 Points
1 Answer
Robert Hecht
6,314 Points
SELECT first_name || " " || last_name || " " || "<" || email || ">" FROM patrons AS 'to_field';

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

Robert Hecht
6,314 Points
1 Answer
David Wells
12,865 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,865 Points
2 Answers
Ker Sing Tan
9,006 Points
solve missing where cause error

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

Ker Sing Tan
9,006 Points
1 Answer
sulaiman abouabdah
5,314 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
5,314 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,839 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
3,839 Points
2 Answers

Prev Page 1 of 10 Next

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