Treehouse | Community | Retrieving Specific Columns of Information

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
keeps stating: Did you select from "results" table My answer: SELECT * FROM results WHERE away_team < 10;

Posted January 6, 2020 8:22pm by vona goodpaster

vona goodpaster
1,719 Points
1 Answer
vona goodpaster
1,719 Points
system states this is incorrect: select * from results where home_team > 12;

Posted January 6, 2020 8:09pm by vona goodpaster

vona goodpaster
1,719 Points
1 Answer
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 first_name, last_name, FROM users WHERE username = "wig_lady";

Posted December 3, 2019 10:00pm by DCI Seven

DCI Seven
828 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
Dominick Brady
2,319 Points
SELECT * FROM home_team WHERE home_score > 12; Is there a syntax error with the query? I don't understand the issue.

Posted December 2, 2019 8:42pm by Dominick Brady

Dominick Brady
2,319 Points
2 Answers
reggaeshark
8,542 Points
There should be a mention of using brackets for ordering.

Posted December 1, 2019 9:25am by reggaeshark

reggaeshark
8,542 Points
1 Answer
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
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
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
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
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
Luigi Cinque
1,548 Points
SQL %

Posted September 15, 2019 6:51pm by Luigi Cinque

Luigi Cinque
1,548 Points
1 Answer
Cliona Dowling
559 Points
What is incorrect in this query:

Posted September 4, 2019 4:01pm by Cliona Dowling

Cliona Dowling
559 Points
1 Answer
Sung-Fu Han
3,890 Points
why the query won't work in task 2 of 3? SELECT * FROM　products WHERE price != 9.99;

Posted August 29, 2019 9:27am by Sung-Fu Han

Sung-Fu Han
3,890 Points
2 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
Yusuf Balogun
1,829 Points
In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name.

Posted August 17, 2019 11:24pm by Yusuf Balogun

Yusuf Balogun
1,829 Points
1 Answer
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
Gurveer Singh
11,382 Points
i can't understand this question

Posted August 15, 2019 3:04am by Gurveer Singh

Gurveer Singh
11,382 Points
2 Answers
bright chibuike
3,245 Points
matching patter

Posted August 11, 2019 12:41am by bright chibuike

bright chibuike
3,245 Points
4 Answers
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
Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
Select all columns with missing data? Help

Posted July 29, 2019 8:40pm by Jesse Dispoto

Jesse Dispoto
Front End Web Development Techdegree Graduate 14,538 Points
1 Answer
Remi Vledder
14,144 Points
It's not clear in the question that all columns should be selected.

Posted July 24, 2019 9:01am by Remi Vledder

Remi Vledder
14,144 Points
0 Answers
Cosmin Iuga
2,352 Points
I'm stuck here. please help

Posted July 22, 2019 11:29pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
4 Answers
Cosmin Iuga
2,352 Points
I'm stuck. Sorry

Posted July 22, 2019 10:03pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
2 Answers

Prev Page 4 of 10 Next

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