Treehouse | Community | Filtering by Comparing Values

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
Omolade Akinwumi
1,068 Points
WHERE CONDITION

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

Omolade Akinwumi
1,068 Points
2 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
João Mendonça
2,793 Points
Stuck on SQL question, did I not SELECT?

Posted October 4, 2021 11:36am by João Mendonça

João Mendonça
2,793 Points
1 Answer
Shain Jones
1,315 Points
seems to be simple but I am missing something. task is get results of home team scores <=. Not liking my syntax

Posted August 28, 2020 2:06pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Joe Li
3,234 Points
What column am I missing from my query?

Posted May 28, 2020 4:34pm by Joe Li

Joe Li
3,234 Points
2 Answers
Richard Sun
11,257 Points
What is wrong with this query?

Posted March 14, 2020 11:19pm by Richard Sun

Richard Sun
11,257 Points
1 Answer
mihneaburtescu
348 Points
I dont understand

Posted February 28, 2020 5:02am by mihneaburtescu

mihneaburtescu
348 Points
1 Answer
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
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
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
gerardo keys
14,292 Points
These challenges will not submit

Posted July 21, 2019 8:39pm by gerardo keys

gerardo keys
14,292 Points
2 Answers
Michelle Clark
1,032 Points
I am selecting all columns from the products table (id, name, description, price) but not registering in exercise...

Posted May 1, 2019 2:26pm by Michelle Clark

Michelle Clark
1,032 Points
2 Answers
Ben Brown
799 Points
I am typing in results for the Table, but it is saying that I am not selecting from the results table

Posted December 13, 2018 3:58pm by Ben Brown

Ben Brown
799 Points
1 Answer
PLUS

Brandy Steals
Courses Plus Student 5,457 Points
Did you select from the 'results' table error message

Posted October 27, 2018 1:37am by Brandy Steals

Brandy Steals
Courses Plus Student 5,457 Points
1 Answer
Fairooz Adams
2,704 Points
Problem with code.

Posted September 28, 2018 9:22pm by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
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
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
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
A X
12,842 Points
Discovered bug in Filtering by comparing columns Challenge Task

Posted January 17, 2016 10:08pm by A X

A X
12,842 Points
2 Answers

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

Rojina Pradhan

Rojina Pradhan

Omolade Akinwumi

Omolade Akinwumi

Lacey Walker

Lacey Walker

João Mendonça

João Mendonça

Shain Jones

Shain Jones

Joe Li

Joe Li

Richard Sun

Richard Sun

mihneaburtescu

mihneaburtescu

vona goodpaster

vona goodpaster

vona goodpaster

vona goodpaster

Dominick Brady

Dominick Brady

Remi Vledder

Remi Vledder

gerardo keys

gerardo keys

Michelle Clark

Michelle Clark

Ben Brown

Ben Brown

Brandy Steals

Brandy Steals

Fairooz Adams

Fairooz Adams

Ruchi P

Ruchi P

Shain Jones

Shain Jones

MUSTAFA TAHA

MUSTAFA TAHA

A X

A X