Treehouse | Community | Categorizing Your Output with 'AS'

🤑 Join the Treehouse affiliate program and earn 25% commission!

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

missjones74
239 Points
select home_team as "Home Team",home_score as "Home Score",away_team as "Away Team",away_score as "Away Score",played_on

Posted August 5, 2024 6:48pm by missjones74

missjones74
239 Points
2 Answers
techo noice
363 Points
please help in understanding

Posted January 6, 2024 11:40am by techo noice

techo noice
363 Points
2 Answers
Nameer Jamal
309 Points
select first_name as "First Name", last_name as "Last Name", phone as " Phone Number" from phone_book;

Posted November 27, 2023 6:12pm by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Arnold Kim
359 Points
did you select from

Posted November 13, 2023 9:35pm by Arnold Kim

Arnold Kim
359 Points
0 Answers
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,493 Points
Bummer: Did you select from the `users` table?

Posted January 11, 2021 1:22am by cgeorge

cgeorge
5,493 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

Prev Page 1 of 2 Next

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