Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Mayo Toyota
2,035 Points
genre = "Science Fiction"

Posted February 15, 2020 9:17pm by Mayo Toyota

Mayo Toyota
2,035 Points
1 Answer
Fredrick Adegoke
1,983 Points
Unsure why my query is failing

Posted December 11, 2019 10:28am by Fredrick Adegoke

Fredrick Adegoke
1,983 Points
1 Answer
Luigi Cinque
1,548 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,548 Points
2 Answers
Adam Tyler
5,407 Points
Why does this need a WHERE clause?

Posted June 19, 2019 4:02pm by Adam Tyler

Adam Tyler
5,407 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
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
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
Dinesh Dewnarain
1,089 Points
Limit rows

Posted February 10, 2019 4:12pm by Dinesh Dewnarain

Dinesh Dewnarain
1,089 Points
1 Answer
Alejandro Carvajal
9,100 Points
Question not written correctly

Posted January 8, 2019 6:45pm by Alejandro Carvajal

Alejandro Carvajal
9,100 Points
1 Answer
Alejandro Carvajal
9,100 Points
Why would a WHERE clause be necessary if I could just return the asked-for information by just ordering with ORDER BY???

Posted January 8, 2019 6:33pm by Alejandro Carvajal

Alejandro Carvajal
9,100 Points
1 Answer
Gia Hoang Nguyen
4,137 Points
what is wrong with my query?

Posted December 22, 2018 5:14am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
0 Answers
kekai borah
855 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted December 7, 2018 6:15am by kekai borah

kekai borah
855 Points
2 Answers
Shahrukh Azhar Khan
2,135 Points
I am having problems writing the code for this challenge. Can someone please help me! Thanks

Posted November 12, 2018 11:06pm by Shahrukh Azhar Khan

Shahrukh Azhar Khan
2,135 Points
2 Answers
Rhea Khanna
2,838 Points
Limiting data with SQL

Posted October 18, 2018 11:27am by Rhea Khanna

Rhea Khanna
2,838 Points
2 Answers
Sandeep Padda
2,781 Points
Help with this question?

Posted October 16, 2018 12:53am by Sandeep Padda

Sandeep Padda
2,781 Points
1 Answer
Loy Yee Ko
5,814 Points
SELECT * FROM books WHERE genre ORDER BY first_published ASC LIMIT 5; fail to return any result

Posted October 13, 2018 4:47pm by Loy Yee Ko

Loy Yee Ko
5,814 Points
1 Answer
Raymond Moore
8,949 Points
SQL Query ?

Posted October 6, 2018 11:01pm by Raymond Moore

Raymond Moore
8,949 Points
1 Answer
Shain Jones
1,151 Points
Unsure how to fix the code as the ORDERED BY is there. How can I fix this? Thanks in advance.

Posted October 5, 2018 8:00pm by Shain Jones

Shain Jones
1,151 Points
1 Answer
Karen Shumate
13,579 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_publishedcolumn.

Posted September 29, 2018 1:35am by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
PRO

ct7
Pro Student 964 Points
Challenge task 1 of 2

Posted September 1, 2018 7:29pm by ct7

ct7
Pro Student 964 Points
2 Answers
Walter Guerrero
6,841 Points
We're using the library database again. There's a books table. There's a title, author, genre and first_published column

Posted June 7, 2018 11:41am by Walter Guerrero

Walter Guerrero
6,841 Points
1 Answer
Fathima Fas-ha
6,847 Points
Reporting with SQL

Posted May 24, 2018 9:47am by Fathima Fas-ha

Fathima Fas-ha
6,847 Points
1 Answer

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