Treehouse | Community | Retrieving Specific Columns of Information

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
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
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
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
sevdiye ozlutas
1,453 Points
What is the SQL code should be for question 5 about the results in Rugby Match?

Posted August 17, 2019 12:15pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Emily Novakovich
175 Points
How can I code SQL in excel?

Posted August 1, 2019 8:47pm by Emily Novakovich

Emily Novakovich
175 Points
3 Answers
Dmitry Sidorenko
1,692 Points
Hi! What would be a query in reviews table to show correlated movie_title from movie table instead of movie_id?

Posted July 22, 2019 5:33pm by Dmitry Sidorenko

Dmitry Sidorenko
1,692 Points
2 Answers
Marcos Treviño Rodriguez
5,711 Points
Hello TH Team The actors table is crashing my PC, when i'm trying to see what is inside it in Launch SQL Playground. BR

Posted July 19, 2019 6:05am by Marcos Treviño Rodriguez

Marcos Treviño Rodriguez
5,711 Points
4 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
Thomas Beckett
2,727 Points
I have been unable to complete this because it continues to fail to load. When I click "Check Work" it just spins.

Posted June 6, 2019 3:05pm by Thomas Beckett

Thomas Beckett
2,727 Points
2 Answers
Felix Belga
4,828 Points
what am I doing wrong

Posted May 8, 2019 6:38pm by Felix Belga

Felix Belga
4,828 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
Luke Rohm
4,679 Points
SQL error for selecting all data from customer_address

Posted April 4, 2019 2:54am by Luke Rohm

Luke Rohm
4,679 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
sulaiman abouabdah
5,314 Points
Download Link for the databases

Posted March 12, 2019 1:22pm by sulaiman abouabdah

sulaiman abouabdah
5,314 Points
3 Answers
PLUS

Patrick Maxwell
Courses Plus Student 6,249 Points
trouble understanding declaring SELECT * FORM comments!!?

Posted February 24, 2019 1:47am by Patrick Maxwell

Patrick Maxwell
Courses Plus Student 6,249 Points
1 Answer
Erik L
Full Stack JavaScript Techdegree Graduate 19,470 Points
at 3:50 the video kind of starts to glitch...

Posted January 30, 2019 5:07am by Erik L

Erik L
Full Stack JavaScript Techdegree Graduate 19,470 Points
2 Answers
Erik L
Full Stack JavaScript Techdegree Graduate 19,470 Points
Offsite resources

Posted January 30, 2019 3:50am by Erik L

Erik L
Full Stack JavaScript Techdegree Graduate 19,470 Points
2 Answers
Ali Imran
4,311 Points
Help please

Posted January 12, 2019 4:47am by Ali Imran

Ali Imran
4,311 Points
1 Answer
PLUS

Patrick Maxwell
Courses Plus Student 6,249 Points
having trouble making more then one linked SELECT*FROM EXAMPLE;

Posted December 16, 2018 4:56am by Patrick Maxwell

Patrick Maxwell
Courses Plus Student 6,249 Points
1 Answer
keku mili
904 Points
Write a SQL query to answer the following question. What are all the products in the products table?

Posted December 5, 2018 2:36am by keku mili

keku mili
904 Points
2 Answers
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
Abiel Ortega
2,171 Points
How to Practice SQL commands and how to work with DataBases at home?

Posted November 2, 2018 4:46am by Abiel Ortega

Abiel Ortega
2,171 Points
2 Answers
Rusell Shamu
4,592 Points
id column

Posted October 22, 2018 7:32pm by Rusell Shamu

Rusell Shamu
4,592 Points
2 Answers
Dilwar Rahman
3,750 Points
We're still in the e-commerce database. This time, from the products table, get the name of every product.

Posted October 14, 2018 1:12pm by Dilwar Rahman

Dilwar Rahman
3,750 Points
2 Answers

Prev Page 2 of 3 Next

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