Treehouse | Community | Searching Tables with 'WHERE'

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

A X
12,842 Points
What is a Foreign Key?

Posted March 30, 2020 10:35pm by A X

A X
12,842 Points
2 Answers
fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
SQL Function VS JS Function?

Posted March 27, 2020 11:34pm by fairest

fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
1 Answer
Kalif Yusuf
4,056 Points
Not sure, what is wrong with the away I answered the question

Posted February 29, 2020 7:04pm by Kalif Yusuf

Kalif Yusuf
4,056 Points
1 Answer
Diadie Camara
1,842 Points
select first_name|| " " || UPPER(last_name) AS Full_name, library_id from patrons

Posted February 25, 2020 9:36pm by Diadie Camara

Diadie Camara
1,842 Points
2 Answers
Brenna Hyland
1,774 Points
Hello! Confused by the following error: "Bummer: Was expecting 4 entries in the products table. There's only 3"

Posted February 15, 2020 12:04am by Brenna Hyland

Brenna Hyland
1,774 Points
4 Answers
PLUS

youssef b10ta
Courses Plus Student 2,755 Points
how im supposed t understand this ? Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted January 16, 2020 10:09am by youssef b10ta

youssef b10ta
Courses Plus Student 2,755 Points
2 Answers
Stephanie Albright
5,690 Points
Can't find my syntax error.

Posted January 14, 2020 10:21pm by Stephanie Albright

Stephanie Albright
5,690 Points
2 Answers
Mohd Aamir Mir
3,281 Points
where am i wrong in writing this query?

Posted January 11, 2020 11:57am by Mohd Aamir Mir

Mohd Aamir Mir
3,281 Points
2 Answers
Khadija Smith
547 Points
Why is my answer incorrect?

Posted January 2, 2020 9:30pm by Khadija Smith

Khadija Smith
547 Points
1 Answer
Khadija Smith
547 Points
Filtering Dates

Posted December 31, 2019 3:30pm by Khadija Smith

Khadija Smith
547 Points
- Databases
1 Answer
DCI Seven
828 Points
INSERT INTO with NULL

Posted December 12, 2019 12:35am 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
Eric Pan
13,398 Points
syntax error near "on" for join

Posted November 26, 2019 12:09am by Eric Pan

Eric Pan
13,398 Points
1 Answer
Riley Egan
2,452 Points
I'm at a loss as far as what to do. I've re-watched the video several times and cannot get past this point.

Posted November 20, 2019 7:47pm by Riley Egan

Riley Egan
2,452 Points
2 Answers
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
Jerry Lombardo
945 Points
Date Datatypes Task

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

Jerry Lombardo
945 Points
4 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
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
INNER JOIN 3 Table and Multiple Columns.

Posted September 30, 2019 10:40pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
2 Answers
Elizabeth Hinson
Full Stack JavaScript Techdegree Graduate 15,852 Points
eCommerce Database modification

Posted September 10, 2019 2:47pm by Elizabeth Hinson

Elizabeth Hinson
Full Stack JavaScript Techdegree Graduate 15,852 Points
2 Answers
sevdiye ozlutas
1,453 Points
what should be the code for challenge 1 for finding the length of TEXT, I have tried different methods

Posted August 26, 2019 1:43pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
sevdiye ozlutas
1,453 Points
What should be the SQL code for challenge one? I have tried different ways but it keeps giving me an error

Posted August 26, 2019 12:52pm by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
3 Answers
sevdiye ozlutas
1,453 Points
What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Posted August 26, 2019 10:18am by sevdiye ozlutas

sevdiye ozlutas
1,453 Points
1 Answer
Paul Brubaker
14,290 Points
Forgot about HAVING keyword and came up with this monstrosity.

Posted August 26, 2019 3:37am by Paul Brubaker

Paul Brubaker
14,290 Points
3 Answers
Yung Kazi
6,997 Points
Keyword OFFSET I am actually confused about what OFFSET is doing. [SOLVED]

Posted August 24, 2019 5:35am by Yung Kazi

Yung Kazi
6,997 Points
2 Answers
Tommy Gebru
30,164 Points
Challenge Task 4 of 4 Bummer: SQL Error: near "SELECT": syntax error

Posted August 22, 2019 10:12pm by Tommy Gebru

Tommy Gebru
30,164 Points
2 Answers
Skylar Gordon
7,943 Points
What does this return, if it doesn't return all sales to female customers?

Posted May 10, 2019 9:58pm by Skylar Gordon

Skylar Gordon
7,943 Points
2 Answers
Hayley Martin
5,838 Points
How to put angle brackets around the data in a columns fields. Help!

Posted November 3, 2016 3:24pm by Hayley Martin

Hayley Martin
5,838 Points
- Databases
4 Answers
Brane Opačič
6,686 Points
SELECT all patrons with "outstanding books"...

Posted October 24, 2016 9:47am by Brane Opačič

Brane Opačič
6,686 Points
- Databases
7 Answers
Shawn Jass
7,151 Points
Trying to check Challenge Task 1 of 5 --In a car database...

Posted September 16, 2016 2:20am by Shawn Jass

Shawn Jass
7,151 Points
- Databases
7 Answers
Jeremy Pzygode
4,499 Points
Reporting with SQL Challenge Task 1 out of 2

Posted August 27, 2016 12:10am by Jeremy Pzygode

Jeremy Pzygode
4,499 Points
- Databases
8 Answers

Prev Page 341 of 389 Next

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