Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Arush Sharma
1,234 Points
This is the error message when I try to execute my query - " Your query retrieve the dates in the correct format (%m/%Y)

Posted January 22, 2020 12:43pm by Arush Sharma

Arush Sharma
1,234 Points
0 Answers
Arush Sharma
1,234 Points
I don't understand what is wrong in my query, How should I move to next question or see the solution of this one ?

Posted January 22, 2020 6:08am by Arush Sharma

Arush Sharma
1,234 Points
1 Answer
Mohd Aamir Mir
3,045 Points
select title,STRFTIME(%m%y,date_released) as month_year_released from movies;

Posted January 20, 2020 7:18am by Mohd Aamir Mir

Mohd Aamir Mir
3,045 Points
1 Answer
PRO

youssef b10ta
Pro Student 2,670 Points
how im supposed t understand this ? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted January 16, 2020 10:09am by youssef b10ta

youssef b10ta
Pro Student 2,670 Points
2 Answers
Stephanie Albright
4,915 Points
Can't find my syntax error.

Posted January 14, 2020 10:21pm by Stephanie Albright

Stephanie Albright
4,915 Points
2 Answers
Mohd Aamir Mir
3,045 Points
select email from customers where REPLACE(email,"@","<at>") as obfuscated_email;

Posted January 11, 2020 8:12pm by Mohd Aamir Mir

Mohd Aamir Mir
3,045 Points
1 Answer
Mohd Aamir Mir
3,045 Points
where am i wrong in writing this query?

Posted January 11, 2020 11:57am by Mohd Aamir Mir

Mohd Aamir Mir
3,045 Points
2 Answers
Stephanie Albright
4,915 Points
Help please

Posted January 10, 2020 7:14pm by Stephanie Albright

Stephanie Albright
4,915 Points
3 Answers
Maryam Naz
2,781 Points
how to combine "AS" statement so I wont have to re-type AS each time?

Posted December 31, 2019 12:51am by Maryam Naz

Maryam Naz
2,781 Points
1 Answer
Maryam Naz
2,781 Points
can someone define "string literal" and identifier"? I tried the web, and still unclear. Thanks in advance.

Posted December 30, 2019 10:58pm by Maryam Naz

Maryam Naz
2,781 Points
1 Answer
Charles Fields
3,342 Points
Has anyone been able to satisfy the question of querying to this format? Andrew Chalkley <andrew@teamtreehouse.com>

Posted December 19, 2019 8:19pm by Charles Fields

Charles Fields
3,342 Points
1 Answer
Fredrick Adegoke
1,983 Points
Unsure why my query is failing

Posted December 11, 2019 10:28am by Fredrick Adegoke

Fredrick Adegoke
1,983 Points
1 Answer
Riley Egan
1,838 Points
I'm at a loss as far as what to do. I've re-watched the video several times and cannot get past this point.

Posted November 20, 2019 7:47pm by Riley Egan

Riley Egan
1,838 Points
2 Answers
Jessica Schteiden
3,254 Points
Issue with Concatenation Function

Posted November 16, 2019 4:43am by Jessica Schteiden

Jessica Schteiden
3,254 Points
1 Answer
Jerry Lombardo
945 Points
Date Datatypes Task

Posted November 14, 2019 9:49pm by Jerry Lombardo

Jerry Lombardo
945 Points
4 Answers
Jerry Lombardo
945 Points
Getting the Grand Total exercise

Posted November 1, 2019 9:36pm by Jerry Lombardo

Jerry Lombardo
945 Points
1 Answer
Jerry Lombardo
945 Points
Count Challenge Task 1

Posted October 29, 2019 7:15pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Duane McAllister
2,858 Points
Am I doing something wrong with how I'm coding

Posted October 25, 2019 8:02pm by Duane McAllister

Duane McAllister
2,858 Points
1 Answer
Jerry Lombardo
945 Points
Concatenation

Posted October 24, 2019 9:12pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Kimberlee Johnson
5,343 Points
Small typo in "Changine" questions (SQL Playground - Stage 2 Practice)?

Posted October 23, 2019 5:47pm by Kimberlee Johnson

Kimberlee Johnson
5,343 Points
1 Answer
juannie jimenez
2,859 Points
trying to figure out why my answer is wrong concatenating these columns and Alias it to to_field

Posted October 22, 2019 7:15pm by juannie jimenez

juannie jimenez
2,859 Points
1 Answer
Steve Rogers
2,801 Points
Problem with code

Posted October 21, 2019 9:14pm by Steve Rogers

Steve Rogers
2,801 Points
3 Answers
Casey Fulmore
1,804 Points
I'm not sure why I'm getting an error when trying to run this code. My notes show that this should be accurate.

Posted October 8, 2019 3:36pm by Casey Fulmore

Casey Fulmore
1,804 Points
2 Answers
Orchid Li
2,013 Points
In the library database there's a patrons table with the columns id, first_name, last_name, address, email, library_id,

Posted October 7, 2019 7:02pm by Orchid Li

Orchid Li
2,013 Points
2 Answers
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 8,385 Points
Could someone pls tell me whats wrong with this statement.

Posted October 2, 2019 7:39pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 8,385 Points
4 Answers
Sharim Babar
2,647 Points
My result looks like the example but it is still wrong, why is that?

Posted September 30, 2019 8:27pm by Sharim Babar

Sharim Babar
2,647 Points
1 Answer
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 8,385 Points
Please help me with the syntax for this SQL statement.

Posted September 28, 2019 8:28pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 8,385 Points
2 Answers
newtocoding
4,940 Points
How to answer this challenge?

Posted September 25, 2019 12:17pm by newtocoding

newtocoding
4,940 Points
1 Answer
Zach Johnston
1,350 Points
I'm not sure how this isn't pulling the correct count. SELECT COUNT(genre) AS genre_count FROM books GROUP BY genre

Posted September 16, 2019 10:43pm by Zach Johnston

Zach Johnston
1,350 Points
1 Answer
Luigi Cinque
1,548 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,548 Points
2 Answers

Prev Page 1 of 11 Next

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