Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Miroslav Pasajlic
795 Points
The columns you selected were named Home Team, Home Score, Away team, Away Score, Date Played and not 'Home Team', 'Home

Posted December 20, 2022 2:36pm by Miroslav Pasajlic

Miroslav Pasajlic
795 Points
1 Answer
K. Brice Perez
15,095 Points
How do I write an as function to retrieve the product name and product description

Posted March 3, 2022 5:48pm by K. Brice Perez

K. Brice Perez
15,095 Points
2 Answers
Anne Olaribigbe
154 Points
My code is not working Here is the code

Posted November 7, 2021 7:43pm by Anne Olaribigbe

Anne Olaribigbe
154 Points
1 Answer
Steven Crutchfield
311 Points
Syntax on SQL Alias error

Posted June 27, 2021 2:26pm by Steven Crutchfield

Steven Crutchfield
311 Points
2 Answers
cgeorge
5,492 Points
Bummer: Did you select from the `users` table?

Posted January 11, 2021 1:22am by cgeorge

cgeorge
5,492 Points
1 Answer
Aravind Rangaswamy
2,035 Points
this sports team database there's a results table with the columns of id, home_team, home_score, away_team, away_score

Posted September 8, 2020 8:29am by Aravind Rangaswamy

Aravind Rangaswamy
2,035 Points
1 Answer
Usha Rani
107 Points
using as and special character " " but not getting correct query

Posted August 28, 2020 8:56pm by Usha Rani

Usha Rani
107 Points
1 Answer
Blake Miller
247 Points
I think there is a bug not letting me move on. I believe this query is correct.

Posted April 26, 2020 9:20pm by Blake Miller

Blake Miller
247 Points
1 Answer
PLUS

Abu-al Fahad
Courses Plus Student 719 Points
whatis the correct answer

Posted January 23, 2020 10:47am by Abu-al Fahad

Abu-al Fahad
Courses Plus Student 719 Points
0 Answers
vona goodpaster
1,719 Points
I am no sure why my code is incorrect for challenge task 3 of 4.

Posted January 2, 2020 7:10pm by vona goodpaster

vona goodpaster
1,719 Points
4 Answers
DCI Seven
828 Points
SELECT name AS "Product Name", description AS "Product Description", FROM products; whats wrong with this Query

Posted December 3, 2019 8:13pm by DCI Seven

DCI Seven
828 Points
1 Answer
DCI Seven
828 Points
SELECT name AS "Product Name", description AS "Product Description" FROM products;

Posted December 3, 2019 7:28pm by DCI Seven

DCI Seven
828 Points
2 Answers
Hien Ha
1,417 Points
What wrong with my code

Posted November 19, 2019 10:27pm by Hien Ha

Hien Ha
1,417 Points
1 Answer
Victor Melvin
1,679 Points
What is wrong with my syntax on this AS output Query ?

Posted November 18, 2019 7:27pm by Victor Melvin

Victor Melvin
1,679 Points
1 Answer
terri ray
870 Points
I am not sure what I did wrong: select id as "Username",first_name as "First Name",last_name as "Last Name" from users;

Posted November 11, 2019 11:51am by terri ray

terri ray
870 Points
1 Answer
shiny peanut
5,113 Points
AS Keyword in SQL

Posted August 18, 2019 4:02pm by shiny peanut

shiny peanut
5,113 Points
3 Answers
Dilan Patel
2,863 Points
I cannot seem to figure out where I went wrong?

Posted June 20, 2019 11:05am by Dilan Patel

Dilan Patel
2,863 Points
1 Answer
brayden gosse
2,226 Points
In this sports team database there's a results table with the columns of id, home_team, home_score, away_team, away_scor

Posted May 7, 2019 11:55pm by brayden gosse

brayden gosse
2,226 Points
0 Answers
Aaron Howarth
169 Points
What am I missing here with my syntax?

Posted April 10, 2019 6:53pm by Aaron Howarth

Aaron Howarth
169 Points
1 Answer
Elise Glynn
529 Points
Why and when would we need to use aliases?

Posted April 2, 2019 3:36pm by Elise Glynn

Elise Glynn
529 Points
1 Answer
Marcelo Campos
176 Points
How can I build the SQL challenge ?

Posted November 13, 2018 8:08pm by Marcelo Campos

Marcelo Campos
176 Points
2 Answers
Salem Osi
1,928 Points
SQL basics help/Categorizing with AS

Posted September 5, 2018 2:37am by Salem Osi

Salem Osi
1,928 Points
1 Answer
Fairooz Adams
2,704 Points
Did you ever hear the tragedy of Darth Plagueis The Wise? I thought not. It's not a story the Jedi would tell you. It's

Posted September 4, 2018 3:18pm by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
Erin Clayton
3,840 Points
What's wrong with this code? Looks good to me?

Posted August 18, 2018 1:47pm by Erin Clayton

Erin Clayton
3,840 Points
2 Answers
Lanie Haynes
2,691 Points
I am not sure what is off about my syntax here

Posted August 17, 2018 7:23pm by Lanie Haynes

Lanie Haynes
2,691 Points
1 Answer
Elia Malmsten
5,953 Points
I can't find the error in my code

Posted July 10, 2018 5:11pm by Elia Malmsten

Elia Malmsten
5,953 Points
1 Answer
Luis Ponce
2,290 Points
What is wrong with the folllowing query? SELECT name AS Product Name,description AS Product Description, FROM products;

Posted June 25, 2018 4:21pm by Luis Ponce

Luis Ponce
2,290 Points
3 Answers
Hatem Zreek
7,739 Points
Mistake in the Challenge!!!

Posted May 8, 2018 1:23am by Hatem Zreek

Hatem Zreek
7,739 Points
1 Answer

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