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
Jace Vanwagoner
6,767 Points
How can I save the SQL Playground practice's to be able to add them to a portfolio???

Posted May 24, 2023 3:14pm by Jace Vanwagoner

Jace Vanwagoner
6,767 Points
1 Answer
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Import Table in my VS code

Posted January 13, 2023 1:33pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 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
PLUS

Angelus Taylor
Courses Plus Student 1,414 Points
This is not working. When I submit my answer, it times out.

Posted March 26, 2022 5:48am by Angelus Taylor

Angelus Taylor
Courses Plus Student 1,414 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
keronn byrd
149 Points
What are all the products in the products table? Title of your question keronn byrd

Posted November 2, 2021 10:35pm by keronn byrd

keronn byrd
149 Points
1 Answer
Tyler Young
1,581 Points
Why can't I use aliases for this query, following an example where first_name can be presented as "First Name"?

Posted September 10, 2021 8:03pm by Tyler Young

Tyler Young
1,581 Points
0 Answers
chris muhirwa
1,112 Points
need help figuring out what am missing in my code

Posted September 2, 2021 3:09am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
Özgür Yildirim
4,088 Points
Solutions are shown directly at the launch of the Playground!

Posted July 14, 2021 1:21pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Steven Crutchfield
311 Points
Syntax on SQL Alias error

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

Steven Crutchfield
311 Points
2 Answers
tejaswini vadnal
1,587 Points
help this following query

Posted May 24, 2021 2:53pm by tejaswini vadnal

tejaswini vadnal
1,587 Points
1 Answer
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
Ra Bha
2,201 Points
Why wouldn't the query here have the last_name before the first_name?

Posted November 9, 2020 4:36pm by Ra Bha

Ra Bha
2,201 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
SHAWNELL HARRISON
16,282 Points
can someone please hellp me?

Posted August 4, 2020 10:04pm by SHAWNELL HARRISON

SHAWNELL HARRISON
16,282 Points
1 Answer
Richard Chintembo
5,400 Points
In the Yorkshire Division Four in Rugby, the team Hessle RUFC have a website that shows their latest matches. Their data

Posted May 23, 2020 2:21pm by Richard Chintembo

Richard Chintembo
5,400 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
Chris Hummel
13,960 Points
The database doesn't respond when I enter my query

Posted April 3, 2020 11:22pm by Chris Hummel

Chris Hummel
13,960 Points
1 Answer
A X
12,842 Points
Why do companies use 3rd party tools to generate reports?

Posted March 30, 2020 9:15pm by A X

A X
12,842 Points
2 Answers
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
PLUS

Abu-al Fahad
Courses Plus Student 719 Points
what is wrong?

Posted January 9, 2020 2:10pm 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
Abbas Ahmed
104 Points
I do not get it

Posted December 14, 2019 2:25pm by Abbas Ahmed

Abbas Ahmed
104 Points
1 Answer
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

Prev Page 1 of 3 Next

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