✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

New No-Code Track! 🚀start learning today!

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

  • 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
    • 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
  • 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 Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
    • Showing results for:
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule
    • Close
  • Alex Hort-Francis
    Alex Hort-Francis
    12,924 Points

    My solution

    Posted on Oct 15, 2023 by Alex Hort-Francis
    Alex Hort-Francis
    12,924 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    0 Answers

  • Cody Stephenson
    Cody Stephenson
    8,361 Points

    My overly explicit solution starting from a different table.

    Posted on May 24, 2021 by Cody Stephenson
    Cody Stephenson
    8,361 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    0 Answers

  • Ahmed Mohamed Fouad
    Ahmed Mohamed Fouad
    11,735 Points

    My Code for this lesson using CTE

    Posted on May 14, 2018 by Ahmed Mohamed Fouad
    Ahmed Mohamed Fouad
    11,735 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    0 Answers

  • Vanessa Van Gilder
    Vanessa Van Gilder
    7,034 Points

    Here's my version of making the schedule. Feedback appreciated.

    Posted on Apr 30, 2018 by Vanessa Van Gilder
    Vanessa Van Gilder
    7,034 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    6 Answers

  • Charlie Harcourt
    Charlie Harcourt
    8,046 Points

    Joining teachers name onto student schedule

    Posted on Feb 15, 2018 by Charlie Harcourt
    Charlie Harcourt
    8,046 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    3 Answers

  • mykolash
    mykolash
    12,955 Points

    Have an idea how to improve building schedule

    Posted on Oct 16, 2017 by mykolash
    mykolash
    12,955 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    2 Answers

  • Noah Fields
    Noah Fields
    13,985 Points

    My version of the answer with subqueries

    Posted on Jul 31, 2017 by Noah Fields
    Noah Fields
    13,985 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    0 Answers

  • Stamos Bolovinos
    Stamos Bolovinos
    4,320 Points

    How to sort on start_time?

    Posted on Jul 20, 2017 by Stamos Bolovinos
    Stamos Bolovinos
    4,320 Points
    • Databases
    • SQL Reporting by Example
    • Day 2: Advanced Selecting
    • Student Schedule

    2 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.