Treehouse | Community | Querying Tables

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

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Fahman Khan
3,798 Points
Select all movies from the years 1999 to 2004. SELECT *FROM movies WHERE years BETWEEN 1999 AND 2004;

Posted June 3, 2015 9:48pm by Fahman Khan

Fahman Khan
3,798 Points
2 Answers
Stephen Moss
2,285 Points
I've read the documentation and checked against my database and the query is correct, but reporting wrong in the quiz.

Posted May 31, 2015 2:31am by Stephen Moss

Stephen Moss
2,285 Points
2 Answers
dotz
6,733 Points
LIMITING

Posted May 25, 2015 1:53am by dotz

dotz
6,733 Points
1 Answer
Henry Fleisher
460 Points
For Challenge Task 2 of 2, I wrote the following code: "SELECT * FROM movies LIMIT 12, 20." Why is it wrong?

Posted May 23, 2015 6:54pm by Henry Fleisher

Henry Fleisher
460 Points
1 Answer
Becca Ades
4,205 Points
I don't understand what this question is asking me to do: Select all movies with the "year" column that hasn't been popu

Posted May 21, 2015 7:24pm by Becca Ades

Becca Ades
4,205 Points
2 Answers
Becca Ades
4,205 Points
I'm putting the following answer "SELECT * FROM actors LIMIT 1. 100;" and I'm getting an error message. Help!

Posted May 21, 2015 7:16pm by Becca Ades

Becca Ades
4,205 Points
2 Answers
Becca Ades
4,205 Points
I'm writing SELECT actors.name FROM movies; and it's not working and I'm not sure why!

Posted May 21, 2015 6:27pm by Becca Ades

Becca Ades
4,205 Points
1 Answer
Anthony Perera
9,185 Points
The Answers I typed: SELECT * FROM actors LIMIT 100, 99; which is wrong, any suggestions?

Posted May 1, 2015 12:23pm by Anthony Perera

Anthony Perera
9,185 Points
3 Answers
Wilson Bridgestone
5,850 Points
I see a problem with the actors database file. The actors names are not the same as in the workbench file.

Posted March 22, 2015 3:02am by Wilson Bridgestone

Wilson Bridgestone
5,850 Points
0 Answers
Diego Salazar
2,206 Points
How could I use a where datetime.month> January and datetime.year>2015 or something like this

Posted March 18, 2015 2:10am by Diego Salazar

Diego Salazar
2,206 Points
1 Answer
Noah Schill
10,020 Points
Code challenge: am I deeply confused?

Posted March 1, 2015 9:54pm by Noah Schill

Noah Schill
10,020 Points
4 Answers
Richard Williams
994 Points
Video and Description Sync

Posted January 29, 2015 3:05pm by Richard Williams

Richard Williams
994 Points
1 Answer
Yvette Alasti
17,589 Points
Null Challenge 1 not working

Posted January 24, 2015 10:56pm by Yvette Alasti

Yvette Alasti
17,589 Points
2 Answers
Bruce Berdine
13,607 Points
Dealing with NULL Challenge Can't get past this one.... Bummer

Posted January 24, 2015 1:29am by Bruce Berdine

Bruce Berdine
13,607 Points
8 Answers
Jack Dean
5,772 Points
Is the following challenge buggy or am I doing something wrong?

Posted January 23, 2015 2:17pm by Jack Dean

Jack Dean
5,772 Points
6 Answers
Charles Drake
423 Points
After entering a command to create a new table, it doesnt show under the schema, but is valid. Any help?

Posted January 2, 2015 9:56pm by Charles Drake

Charles Drake
423 Points
2 Answers
PLUS

Martin Bornman
Courses Plus Student 12,662 Points
In the code challenge first Question . My Answer Is: SELECT * FROM actors LIMIT 99,100; Help please

Posted November 17, 2014 1:28pm by Martin Bornman

Martin Bornman
Courses Plus Student 12,662 Points
4 Answers
roxana gharegozlou
248 Points
Error messages when doing the challenges (potential bug)

Posted November 17, 2014 5:44am by roxana gharegozlou

roxana gharegozlou
248 Points
1 Answer
Christian Damm
26,486 Points
query with limit

Posted November 5, 2014 1:04pm by Christian Damm

Christian Damm
26,486 Points
3 Answers
Brian Schmitz
11,167 Points
Where am I wrong here:

Posted October 2, 2014 4:55am by Brian Schmitz

Brian Schmitz
11,167 Points
6 Answers
Brian Schmitz
11,167 Points
Where am I wrong here:

Posted October 2, 2014 4:50am by Brian Schmitz

Brian Schmitz
11,167 Points
2 Answers
PLUS

Gareth Powell
Courses Plus Student 7,016 Points
Why did the wildcard operator "%" only pass when placed at end of string?

Posted August 11, 2014 5:23am by Gareth Powell

Gareth Powell
Courses Plus Student 7,016 Points
2 Answers
khmtravel
2,602 Points
Database Foundations: Limiting the Results: Challenge Task 1

Posted June 25, 2014 1:26pm by khmtravel

khmtravel
2,602 Points
2 Answers
Wilner Charles
874 Points
limiting the result set.

Posted May 22, 2014 4:07am by Wilner Charles

Wilner Charles
874 Points
0 Answers
gopi chand nelluri
528 Points
what is the query for this question

Posted May 13, 2014 6:32pm by gopi chand nelluri

gopi chand nelluri
528 Points
1 Answer
Unsubscribed User
11,468 Points
Retrieving a Result Set (Challenge)

Posted April 29, 2014 1:59am by Unsubscribed User

Unsubscribed User
11,468 Points
1 Answer
Shane McKnight
8,821 Points
where is the treehouse_movies_db download available?

Posted March 31, 2014 12:40pm by Shane McKnight

Shane McKnight
8,821 Points
1 Answer
Jacinda Zhong
3,695 Points
SQL workbench - viewing query and results

Posted March 18, 2014 2:55am by Jacinda Zhong

Jacinda Zhong
3,695 Points
2 Answers
PLUS

Jared Sully
Courses Plus Student 344 Points
Colour text

Posted March 16, 2014 8:43am by Jared Sully

Jared Sully
Courses Plus Student 344 Points
0 Answers
Sreng Hong
15,083 Points
Should the query statement write in uppercase or lowercase?

Posted March 5, 2014 4:59am by Sreng Hong

Sreng Hong
15,083 Points
2 Answers

Prev Page 2 of 2 Next

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