Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Freddie Kuhle
5,601 Points
SQL - How can I add a column from one table to my results from another table?

Posted March 30, 2020 10:31am by Freddie Kuhle

Freddie Kuhle
5,601 Points
1 Answer
fairest
Full Stack JavaScript Techdegree Student 14,668 Points
SQL Function VS JS Function?

Posted March 27, 2020 11:34pm by fairest

fairest
Full Stack JavaScript Techdegree Student 14,668 Points
1 Answer
Caleb Newell
4,873 Points
sql as tables

Posted March 27, 2020 12:03pm by Caleb Newell

Caleb Newell
4,873 Points
1 Answer
Tafari Carnegie
1,290 Points
select genre,count(distinct genre) as total_genres from books group by genre

Posted March 25, 2020 10:15pm by Tafari Carnegie

Tafari Carnegie
1,290 Points
1 Answer
Tafari Carnegie
1,290 Points
Hi, I believe my code is correct but for some reason, it is saying it isn't. I have done what the question has asked me.

Posted March 19, 2020 2:12am by Tafari Carnegie

Tafari Carnegie
1,290 Points
1 Answer
Caleb Newell
4,873 Points
Help with this SQL query

Posted March 18, 2020 7:43pm by Caleb Newell

Caleb Newell
4,873 Points
1 Answer
Caleb Newell
4,873 Points
SQL limit

Posted March 11, 2020 1:56pm by Caleb Newell

Caleb Newell
4,873 Points
3 Answers
Marina Toto
1,408 Points
Im getting the tip of putting angle brackets for an email - but I dont know how to do it

Posted March 9, 2020 7:08pm by Marina Toto

Marina Toto
1,408 Points
2 Answers
Ân Nguyễn Hoàng
3,653 Points
is this a bug ?

Posted March 7, 2020 11:27pm by Ân Nguyễn Hoàng

Ân Nguyễn Hoàng
3,653 Points
1 Answer
Kalif Yusuf
4,056 Points
Not sure, what is wrong with the away I answered the question

Posted February 29, 2020 7:04pm by Kalif Yusuf

Kalif Yusuf
4,056 Points
1 Answer
Claire Brehm
9,088 Points
Having trouble getting the correct answer for task 2 here in the changing cases of strings task

Posted February 26, 2020 10:35pm by Claire Brehm

Claire Brehm
9,088 Points
0 Answers
Diadie Camara
1,842 Points
select first_name|| " " || UPPER(last_name) AS Full_name, library_id from patrons

Posted February 25, 2020 9:36pm by Diadie Camara

Diadie Camara
1,842 Points
2 Answers
Mayo Toyota
2,121 Points
genre = "Science Fiction"

Posted February 15, 2020 9:17pm by Mayo Toyota

Mayo Toyota
2,121 Points
1 Answer
Zachary keller
3,178 Points
Cant understand the question, mainly the end part

Posted February 12, 2020 5:41pm by Zachary keller

Zachary keller
3,178 Points
2 Answers
Zachary keller
3,178 Points
The way the question is worded confuses me.

Posted February 11, 2020 8:29pm by Zachary keller

Zachary keller
3,178 Points
1 Answer
Timothy Hong
2,949 Points
What am I doing wrong here?

Posted January 30, 2020 1:22pm by Timothy Hong

Timothy Hong
2,949 Points
1 Answer
Daniil Kalinkin
853 Points
I would type in ______ at the end of an`ORDER BY` clause to order in descending order. What should I write here?

Posted January 30, 2020 12:24am by Daniil Kalinkin

Daniil Kalinkin
853 Points
1 Answer
Arush Sharma
2,513 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
2,513 Points
0 Answers
Arush Sharma
2,513 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
2,513 Points
1 Answer
Mohd Aamir Mir
3,281 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,281 Points
1 Answer
PRO

youssef b10ta
Pro Student 2,754 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,754 Points
2 Answers
Stephanie Albright
5,209 Points
Can't find my syntax error.

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

Stephanie Albright
5,209 Points
2 Answers
Mohd Aamir Mir
3,281 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,281 Points
1 Answer
Mohd Aamir Mir
3,281 Points
where am i wrong in writing this query?

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

Mohd Aamir Mir
3,281 Points
2 Answers
Stephanie Albright
5,209 Points
Help please

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

Stephanie Albright
5,209 Points
3 Answers
Maryam Naz
2,962 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,962 Points
1 Answer
Maryam Naz
2,962 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,962 Points
1 Answer
Charles Fields
4,205 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
4,205 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,948 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,948 Points
2 Answers

Prev Page 1 of 12 Next

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