Treehouse | Community | Categorizing Your Output with 'AS'

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

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

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

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

⭐Get support and network on our Discord server! ⭐

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
Rachel Waybill
1,393 Points
is there anywhere in here that i can practice more SQL? Like the input statements, creating a table & things like that?

Posted August 3, 2024 3:01am by Rachel Waybill

Rachel Waybill
1,393 Points
1 Answer
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
n the e-commerce database we have a products table. The columns are id, name, description and price. Find all the produ

Posted December 10, 2023 5:05am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
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
Rojina Pradhan
2,681 Points
Find all the matches in the results table where "Hessle" was playing away as the away team and if they played on or afte

Posted October 3, 2023 2:19pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
2 Answers
Rojina Pradhan
2,681 Points
We're back using the e-commerce database. I only have 10.99 left in my bank account. Write a query that will return all

Posted October 2, 2023 6:05pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
3 Answers
Nataliia Kalinicheva
5,433 Points
I selected 6 columns from 6 and I've got "You didn't select all columns". What should I do?

Posted September 27, 2023 7:54pm by Nataliia Kalinicheva

Nataliia Kalinicheva
5,433 Points
1 Answer
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
Wufei Hong
1,393 Points
don't know what's wrong wiz my code

Posted March 4, 2023 1:51am by Wufei Hong

Wufei Hong
1,393 Points
1 Answer
Joel Fuster
2,429 Points
Are you able to review my script? It returns incorrect but I can't seem to figure out why

Posted February 12, 2023 2:25pm by Joel Fuster

Joel Fuster
2,429 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
Jinamai Joseph
1,773 Points
What should be done when "you did not select all columns" appear? All columns are selected.

Posted October 21, 2022 2:29pm by Jinamai Joseph

Jinamai Joseph
1,773 Points
1 Answer
Spencer Lebel
3,125 Points
Need assistance filtering by dates

Posted August 29, 2022 8:17pm by Spencer Lebel

Spencer Lebel
3,125 Points
1 Answer
Zachary Baca
Full Stack JavaScript Techdegree Graduate 13,982 Points
Not sure what is wrong with this sql statement

Posted August 27, 2022 9:06pm by Zachary Baca

Zachary Baca
Full Stack JavaScript Techdegree Graduate 13,982 Points
1 Answer
Tyler McDonald
Full Stack JavaScript Techdegree Graduate 16,700 Points
More efficient way to solve "Movies with Any Missing Data"?

Posted August 19, 2022 8:35pm by Tyler McDonald

Tyler McDonald
Full Stack JavaScript Techdegree Graduate 16,700 Points
1 Answer
JASON LEE
17,352 Points
Question on Integer data type

Posted June 15, 2022 1:38am by JASON LEE

JASON LEE
17,352 Points
1 Answer
Ryan Hartigan
3,425 Points
Why do we put the date range within parenthesis when we don't put numbers within parenthesis? Is this unique to MySQL?

Posted May 7, 2022 4:38pm by Ryan Hartigan

Ryan Hartigan
3,425 Points
3 Answers
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
Omolade Akinwumi
1,068 Points
WHERE CONDITION

Posted March 25, 2022 8:33am by Omolade Akinwumi

Omolade Akinwumi
1,068 Points
2 Answers
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
james mchugh
6,234 Points
It's telling me I didn't select all columns. I did and I checked the snytax and still getting this error

Posted February 17, 2022 3:00am by james mchugh

james mchugh
6,234 Points
1 Answer
PLUS

Jaqua Starr
Courses Plus Student 972 Points
It keeps saying there is something wrong with my statement, am I missing something?

Posted February 10, 2022 6:45pm by Jaqua Starr

Jaqua Starr
Courses Plus Student 972 Points
0 Answers
Lacey Walker
294 Points
It's saying I'm not selecting from the results table when I am

Posted December 14, 2021 7:27pm by Lacey Walker

Lacey Walker
294 Points
1 Answer
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
nicolaspeterson
8,569 Points
In another video, Andrew used NOT IS instead.

Posted October 24, 2021 9:44am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
Christopher Carey
151 Points
Can you explain how the answer data type is incorrect?

Posted October 5, 2021 10:27pm by Christopher Carey

Christopher Carey
151 Points
1 Answer

Prev Page 1 of 10 Next

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