Treehouse | Community | Categorizing Your Output with 'AS'

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

Join our free workshop and get a Treehouse discount code! 💼 Register here!

New No-Code Track! 🚀 New videos dropping every week—start learning today!

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
Jessica Schteiden
3,254 Points
Hey team, I tried this query out on Q3 but it didn't work. Can someone help me understand why it's breaking?

Posted November 17, 2019 9:24pm by Jessica Schteiden

Jessica Schteiden
3,254 Points
2 Answers
Austin Cumberlander
13,997 Points
student

Posted November 16, 2019 6:41pm by Austin Cumberlander

Austin Cumberlander
13,997 Points
1 Answer
Jessica Schteiden
3,254 Points
Issue with Concatenation Function

Posted November 16, 2019 4:43am by Jessica Schteiden

Jessica Schteiden
3,254 Points
1 Answer
Jerry Lombardo
945 Points
Date Datatypes Task

Posted November 14, 2019 9:49pm by Jerry Lombardo

Jerry Lombardo
945 Points
4 Answers
Steve Rogers
3,285 Points
Left Outer Join question

Posted November 12, 2019 3:18pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Orchid Li
2,024 Points
sqlite> .read NEW_CARS.XLSX Error: near line 1: near "PK": syntax error I transformed the txt file into an excel file.

Posted November 11, 2019 9:39pm by Orchid Li

Orchid Li
2,024 Points
- Databases
0 Answers
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
Seth Johnson
15,200 Points
Question about use of aliases in query statements...

Posted November 8, 2019 2:29am by Seth Johnson

Seth Johnson
15,200 Points
- Databases
2 Answers
Jerry Lombardo
945 Points
Getting the Grand Total exercise

Posted November 1, 2019 9:36pm by Jerry Lombardo

Jerry Lombardo
945 Points
1 Answer
Eric Popper
758 Points
eCommerce Database modification. Challenge Task 1 of 3 Bummer: expecting 4 entries in the products table. There's only 3

Posted October 30, 2019 5:16pm by Eric Popper

Eric Popper
758 Points
1 Answer
Steve Rogers
3,285 Points
trouble

Posted October 29, 2019 10:29pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Jerry Lombardo
945 Points
Count Challenge Task 1

Posted October 29, 2019 7:15pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Karin Naomi
835 Points
Is there a solution video for these exercises (SQL Playground Stage 3 Practice)? Thanks a lot in advance!

Posted October 29, 2019 3:13pm by Karin Naomi

Karin Naomi
835 Points
2 Answers
Duane McAllister
2,858 Points
Am I doing something wrong with how I'm coding

Posted October 25, 2019 8:02pm by Duane McAllister

Duane McAllister
2,858 Points
1 Answer
Antonio Pala
Front End Web Development Techdegree Student 16,928 Points
Am I missing something?

Posted October 24, 2019 10:08pm by Antonio Pala

Antonio Pala
Front End Web Development Techdegree Student 16,928 Points
1 Answer
Jerry Lombardo
945 Points
Concatenation

Posted October 24, 2019 9:12pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Terrence Butler
1,201 Points
Stuck on problem

Posted October 24, 2019 6:09am by Terrence Butler

Terrence Butler
1,201 Points
1 Answer
Kimberlee Johnson
5,343 Points
Small typo in "Changine" questions (SQL Playground - Stage 2 Practice)?

Posted October 23, 2019 5:47pm by Kimberlee Johnson

Kimberlee Johnson
5,343 Points
1 Answer
juannie jimenez
2,859 Points
trying to figure out why my answer is wrong concatenating these columns and Alias it to to_field

Posted October 22, 2019 7:15pm by juannie jimenez

juannie jimenez
2,859 Points
1 Answer
Steve Rogers
3,285 Points
Problem with code

Posted October 21, 2019 9:14pm by Steve Rogers

Steve Rogers
3,285 Points
3 Answers
Steve Rogers
3,285 Points
Counting issue?

Posted October 21, 2019 2:24pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Stheven Cabral
Full Stack JavaScript Techdegree Graduate 29,854 Points
What program do analysts use to write SQL?

Posted October 18, 2019 9:53pm by Stheven Cabral

Stheven Cabral
Full Stack JavaScript Techdegree Graduate 29,854 Points
3 Answers
juannie jimenez
2,859 Points
am i supposed to already know what the id is for practice question , adding new product to ecommerce ?

Posted October 17, 2019 10:55pm by juannie jimenez

juannie jimenez
2,859 Points
1 Answer
Steve Rogers
3,285 Points
The quiz asked me to return a list of employees ordered by salary starting with the highest. I got it wrong?

Posted October 16, 2019 8:00pm by Steve Rogers

Steve Rogers
3,285 Points
2 Answers
Matthew Collier
784 Points
Why does this happen?

Posted October 15, 2019 2:47pm by Matthew Collier

Matthew Collier
784 Points
- Databases
1 Answer
Devin Goodson
907 Points
SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit" ; = Hinkley OR Pettit;

Posted October 15, 2019 7:40am by Devin Goodson

Devin Goodson
907 Points
1 Answer
Cliona Dowling
559 Points
What's the issue with this statement: DELETE FROM users WHERE username = poley_hands;

Posted October 14, 2019 11:35am by Cliona Dowling

Cliona Dowling
559 Points
2 Answers
Casey Fulmore
1,853 Points
I'm not sure why I'm getting an error when trying to run this code. My notes show that this should be accurate.

Posted October 8, 2019 3:36pm by Casey Fulmore

Casey Fulmore
1,853 Points
2 Answers
Ray Thomas
12,478 Points
Does treehouse show how to make an SQL table natively?

Posted October 8, 2019 10:21am by Ray Thomas

Ray Thomas
12,478 Points
- Databases
1 Answer

Prev Page 20 of 389 Next

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