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

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
Alexandra Cianciara
2,465 Points
SQL Database

Posted August 29, 2018 7:46am by Alexandra Cianciara

Alexandra Cianciara
2,465 Points
1 Answer
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Invalid Ratings

Posted August 27, 2018 9:56pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
1 Answer
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Who are these Actors?

Posted August 27, 2018 9:47pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
4 Answers
Ruchi P
123 Points
We have a database that runs a sports team's website. In the results table we have the columns id, home_team, home_score

Posted August 21, 2018 7:24am by Ruchi P

Ruchi P
123 Points
1 Answer
Erin Clayton
3,840 Points
What's up with the SQL Playground mismatch on this video??

Posted August 20, 2018 12:33am by Erin Clayton

Erin Clayton
3,840 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
Shain Jones
1,315 Points
the code challenge is asking if I "selected results as my table." My code is SELECT * FROM results WHERE away_team<10;

Posted August 16, 2018 7:04pm by Shain Jones

Shain Jones
1,315 Points
3 Answers
Moreblessing Machiwenyika
3,613 Points
database

Posted August 7, 2018 11:42am by Moreblessing Machiwenyika

Moreblessing Machiwenyika
3,613 Points
2 Answers
Amy Hsieh
6,023 Points
This is easy but I didn't know what's wrong with my SQL code. I guess played_on means who play in that game.

Posted August 5, 2018 3:11pm by Amy Hsieh

Amy Hsieh
6,023 Points
4 Answers
MUSTAFA TAHA
5,150 Points
why when I write this come I get error what is the wrong? SELECT * FROM results WHERE home_team > 12;

Posted July 25, 2018 8:05pm by MUSTAFA TAHA

MUSTAFA TAHA
5,150 Points
2 Answers
yan wang
2,449 Points
Select Query

Posted July 25, 2018 2:06pm by yan wang

yan wang
2,449 Points
1 Answer
yan wang
2,449 Points
Select Query

Posted July 24, 2018 2:14pm by yan wang

yan wang
2,449 Points
2 Answers
Michael Pashkov
22,024 Points
Hi guys, should I write keywords in upper case or there is no differens?

Posted July 14, 2018 8:07am by Michael Pashkov

Michael Pashkov
22,024 Points
2 Answers
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
PLUS

Jonathan Pina
Courses Plus Student 157 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted June 21, 2018 10:44am by Jonathan Pina

Jonathan Pina
Courses Plus Student 157 Points
2 Answers
Trevor Ward
353 Points
SELECT * FROM results WHERE id = "Hessle" and away_score > 18; Bummer: Did you select from the 'results' table?

Posted June 21, 2018 1:58am by Trevor Ward

Trevor Ward
353 Points
1 Answer
Susan Thatcher
1,217 Points
My code: SELECT username FROM user WHERE last_name= "Chalkley"; It's not working.

Posted June 17, 2018 10:13pm by Susan Thatcher

Susan Thatcher
1,217 Points
2 Answers
adam woolf
1,181 Points
there is a bug here. i believe my syntax is correct

Posted June 12, 2018 12:35am by adam woolf

adam woolf
1,181 Points
1 Answer
ericwidman3
4,679 Points
Not allowing me to continue

Posted June 3, 2018 10:24pm by ericwidman3

ericwidman3
4,679 Points
2 Answers
Nosin mahbub
664 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames

Posted June 3, 2018 7:30pm by Nosin mahbub

Nosin mahbub
664 Points
1 Answer
Hanna Han
4,105 Points
19 th century

Posted May 31, 2018 9:32am by Hanna Han

Hanna Han
4,105 Points
3 Answers
Hanna Han
4,105 Points
Keyword IN usage

Posted May 29, 2018 2:06pm by Hanna Han

Hanna Han
4,105 Points
2 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
PLUS

Ed Peters
Courses Plus Student 567 Points
Hi. I'm stuck on what goes between the two numerical values here.

Posted April 29, 2018 9:25pm by Ed Peters

Ed Peters
Courses Plus Student 567 Points
2 Answers
Gary Sellergren
1,448 Points
So WHERE is the * in the options for this question?

Posted April 13, 2018 6:34pm by Gary Sellergren

Gary Sellergren
1,448 Points
1 Answer
Adam Tatusko
16,589 Points
MySQL Pronunciation

Posted March 27, 2018 2:00pm by Adam Tatusko

Adam Tatusko
16,589 Points
2 Answers
Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
Yeah, Wii U's didn't sell that well...

Posted February 16, 2018 7:41pm by Neil Bircumshaw

Neil Bircumshaw
Full Stack JavaScript Techdegree Student 14,597 Points
4 Answers

Prev Page 7 of 10 Next

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