Treehouse | Community | Filtering by Comparing Values

🤑 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

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
PLUS

Kate Woodroffe
Courses Plus Student 6,685 Points
Stuck on task 4 of querying relational databases, sub queries assessment

Posted April 29, 2019 1:32pm by Kate Woodroffe

Kate Woodroffe
Courses Plus Student 6,685 Points
4 Answers
Faisal Aleissa
1,992 Points
why id did not work

Posted April 27, 2019 11:14pm by Faisal Aleissa

Faisal Aleissa
1,992 Points
1 Answer
Monika Flanigan
622 Points
I am unable to complete this, they are saying I have only entered 3 values. Tried several things, stuck on this one!

Posted April 26, 2019 6:49pm by Monika Flanigan

Monika Flanigan
622 Points
1 Answer
Nelson Pamplona
1,575 Points
I am not sure if I am supposed to include anything but first name, last name and email for this challenge.

Posted April 23, 2019 8:08pm by Nelson Pamplona

Nelson Pamplona
1,575 Points
3 Answers
PLUS

apoorva seeram
Courses Plus Student 182 Points
Any documents which gives the overall idea of sql course?

Posted April 23, 2019 4:24pm by apoorva seeram

apoorva seeram
Courses Plus Student 182 Points
- Databases
1 Answer
Grady Robbins
8,249 Points
Reporting with SQL final assesment: i am thrown off by: LIMIT 0, OFFSET 50. should any rows be returned at all?

Posted April 21, 2019 5:23pm by Grady Robbins

Grady Robbins
8,249 Points
2 Answers
Kevin Lewis
15,088 Points
If you're having trouble installing Mongo on Mac.

Posted April 20, 2019 1:10am by Kevin Lewis

Kevin Lewis
15,088 Points
2 Answers
sofia Heikkila Svensson
3,695 Points
Hi, My code is wrong. The bummer answer is : You should try writing a SELECT query.

Posted April 18, 2019 7:33am by sofia Heikkila Svensson

sofia Heikkila Svensson
3,695 Points
1 Answer
Karl Hogben
462 Points
> SELECT * FROM books WHERE genre = "Fantasy" ORDER BY genre ASC LIMIT 5

Posted April 14, 2019 4:33pm by Karl Hogben

Karl Hogben
462 Points
1 Answer
Muhittin Palamutçu
1,890 Points
I need some help for my Sql Query

Posted April 11, 2019 8:57pm by Muhittin Palamutçu

Muhittin Palamutçu
1,890 Points
- Databases
2 Answers
sj sh
122 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted April 11, 2019 8:37am by sj sh

sj sh
122 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
Ikechukwu Arum
5,337 Points
ERROR: NO SUCH COLUMN

Posted April 9, 2019 6:41pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
3 Answers
PLUS

kevin hudson
Courses Plus Student 11,987 Points
No Help needed but want to share Code with mistakes

Posted April 9, 2019 3:58pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
0 Answers
PLUS

kevin hudson
Courses Plus Student 11,987 Points
Is it a bad approach to use subqueries over CTE and JOINING?

Posted April 8, 2019 6:20pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
2 Answers
PLUS

kevin hudson
Courses Plus Student 11,987 Points
What is penultimate?

Posted April 8, 2019 3:51pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
1 Answer
PLUS

kevin hudson
Courses Plus Student 11,987 Points
The first challenge should include GROUP BY

Posted April 8, 2019 2:51pm by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
5 Answers
Luitzen Hietkamp
7,593 Points
Actor table too large

Posted April 7, 2019 2:15pm by Luitzen Hietkamp

Luitzen Hietkamp
7,593 Points
- Databases
0 Answers
Marat Guysin
1,601 Points
Cannot get the right SQL statement

Posted April 6, 2019 11:28pm by Marat Guysin

Marat Guysin
1,601 Points
1 Answer
PLUS

kevin hudson
Courses Plus Student 11,987 Points
Is there an advanced SQL track to follow later on after the beginner's track?

Posted April 5, 2019 1:29am by kevin hudson

kevin hudson
Courses Plus Student 11,987 Points
1 Answer
Ikechukwu Arum
5,337 Points
related to the subquery challenge using the "IN" Keyword

Posted April 4, 2019 6:40pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
1 Answer
Francesco Sollitto
2,454 Points
I HAVE ADDED THE PRIMARY KEY ON ID, WHY YOU KEEP REPEATING THE SAME BUMMER????

Posted April 4, 2019 9:03am by Francesco Sollitto

Francesco Sollitto
2,454 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
Abdullah Salman
6,461 Points
Quiz - Modifying Data with SQL

Posted April 2, 2019 12:38pm by Abdullah Salman

Abdullah Salman
6,461 Points
1 Answer
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
adam woolf
1,181 Points
select SUM(rating) AS starman_total_ratings From reviews WHERE movie_id="Starman" it says i did not sum correctly

Posted April 2, 2019 4:39am by adam woolf

adam woolf
1,181 Points
1 Answer
Ilya Kotlyar
2,258 Points
Is there a track on online databases?

Posted March 31, 2019 1:18am by Ilya Kotlyar

Ilya Kotlyar
2,258 Points
- Databases
1 Answer
Apoorva Seeram
790 Points
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

Posted March 28, 2019 8:09pm by Apoorva Seeram

Apoorva Seeram
790 Points
2 Answers

Prev Page 25 of 389 Next

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