Join our Live Workshop and land your next Tech Internship! 💼 Register here!

Take our "AI in Tech Jobs" survey and win 3 months free Treehouse!

New No-Code Track! 🚀 New videos dropping every week—start learning today!

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

✨ No-code curious? Check out 4 new FREE Adalo courses and start building an app in minutes — no code required!

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Community Projects
    • Live Sessions
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Community Projects Live Sessions Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Skills
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
  • Mayo Toyota
    Mayo Toyota
    2,121 Points

    genre = "Science Fiction"

    Posted February 15, 2020 9:17pm by Mayo Toyota
    Mayo Toyota
    2,121 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Adam Tyler
    Adam Tyler
    14,865 Points

    Why does this need a WHERE clause?

    Posted June 19, 2019 4:02pm by Adam Tyler
    Adam Tyler
    14,865 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Alejandro Carvajal
    Alejandro Carvajal
    9,100 Points

    Question not written correctly

    Posted January 8, 2019 6:45pm by Alejandro Carvajal
    Alejandro Carvajal
    9,100 Points
    • Databases
    • Reporting with SQL
    • Ordering, Limiting and Paging Results
    • Limiting Results

    1 Answer

  • Nomore Majuru
    Nomore Majuru
    7,881 Points

    database

    Posted September 14, 2018 7:15am by Nomore Majuru
    Nomore Majuru
    7,881 Points
    • Databases

    1 Answer

  • Joshua Lee
    Joshua Lee
    3,625 Points

    Create method to pull random strings from array

    Posted August 28, 2017 7:37pm by Joshua Lee
    Joshua Lee
    3,625 Points
    • iOS

    2 Answers

  • Damion Armentrout
    Damion Armentrout
    8,120 Points

    Why do I get this error: "Your query needs to retrive the earliest 'Science Fiction' book from the `books` table." ?

    Posted May 17, 2017 10:18pm by Damion Armentrout
    Damion Armentrout
    8,120 Points
    • PHP

    2 Answers

  • Stuart Guest-Smith
    Stuart Guest-Smith
    5,343 Points

    Not sure what's wrong? - 'Your query needs to retrieve the earliest 'Science Fiction' book from the `books` table."

    Posted May 6, 2017 11:10pm by Stuart Guest-Smith
    Stuart Guest-Smith
    5,343 Points
    • Databases

    3 Answers

  • harpreet kaur kandola
    harpreet kaur kandola
    1,429 Points

    reporting with SQL

    Posted April 20, 2017 12:23am by harpreet kaur kandola
    harpreet kaur kandola
    1,429 Points
    • Databases

    8 Answers

  • Will Ginsberg
    Will Ginsberg
    2,774 Points

    Misleading error message

    Posted January 16, 2017 7:22pm by Will Ginsberg
    Will Ginsberg
    2,774 Points
    • General Discussion

    1 Answer

  • Victoria Loisi
    Victoria Loisi
    7,070 Points

    Why I need to retrieve the "earliest" book if the sorting order should be made alphabetically?

    Posted September 10, 2016 7:13pm by Victoria Loisi
    Victoria Loisi
    7,070 Points
    • Databases

    2 Answers

  • Kyle B
    Kyle B
    6,383 Points

    SQL query appears correct, return data appears correct, error code appears to have nothing to do with the question?

    Posted August 10, 2016 9:46pm by Kyle B
    Kyle B
    6,383 Points
    • General Discussion

    1 Answer

  • Igor Skoldin
    Igor Skoldin
    6,779 Points

    Why is not it working?

    Posted July 4, 2016 5:30am by Igor Skoldin
    Igor Skoldin
    6,779 Points
    • PHP

    1 Answer

  • filipepacheco
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    filipepacheco
    Full Stack JavaScript Techdegree Student 21,416 Points

    In a library database there's a books table. There's a title, author, genre and first_published column.

    Posted June 29, 2016 6:22am by filipepacheco
    .a{fill-rule:evenodd;}techdegree
    filipepacheco
    Full Stack JavaScript Techdegree Student 21,416 Points
    • PHP

    4 Answers

  • OndÅ™ej Straňanek
    Ondřej Straňanek
    19,637 Points

    Find the earliest Science Fiction book in our library..

    Posted June 18, 2016 11:24am by Ondřej Straňanek
    Ondřej Straňanek
    19,637 Points
    • Databases

    2 Answers

  • Emmet Lowry
    Emmet Lowry
    10,196 Points

    NEED help with challenge 2 of the limiting result task

    Posted June 15, 2016 8:36pm by Emmet Lowry
    Emmet Lowry
    10,196 Points
    • Databases

    3 Answers

  • Garrett Levine
    Garrett Levine
    20,305 Points

    Problem in PHP DB Query Challenge

    Posted June 13, 2016 4:02pm by Garrett Levine
    Garrett Levine
    20,305 Points
    • Databases

    1 Answer

  • Trần Phúc
    Trần Phúc
    2,264 Points

    ISSUE USE ORDER BY AND LIMIT IN SQL

    Posted June 6, 2016 11:32am by Trần Phúc
    Trần Phúc
    2,264 Points
    • Databases

    3 Answers

  • Nathan Hering
    Nathan Hering
    4,506 Points

    Limit and Offset, Having trouble with these challenges

    Posted June 4, 2016 1:01pm by Nathan Hering
    Nathan Hering
    4,506 Points
    • PHP

    3 Answers

  • Edward Li
    Edward Li
    373 Points

    Write a query to bring the 2nd page of result.

    Posted March 6, 2016 10:48am by Edward Li
    Edward Li
    373 Points
    • Databases

    1 Answer

  • Edward Li
    Edward Li
    373 Points

    Bummer! Ten books were expected. 4 were returned in the results.

    Posted March 6, 2016 3:44am by Edward Li
    Edward Li
    373 Points
    • Databases

    2 Answers

  • Edward Li
    Edward Li
    373 Points

    What should I write to retrieve 'Science Fiction' from books?

    Posted March 2, 2016 11:39pm by Edward Li
    Edward Li
    373 Points
    • Databases

    1 Answer

  • Edward Li
    Edward Li
    373 Points

    What should I write the where clause?

    Posted March 2, 2016 10:15pm by Edward Li
    Edward Li
    373 Points
    • Databases

    7 Answers

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

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.