• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Library
  • Community
  • Support
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Go
      • • HTML
      • • iOS
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
      • • Swift
  • kevin hudson
    PRO
    kevin hudson
    Pro Student 9,645 Points

    Is it a bad approach to use subqueries over CTE and JOINING?

    Posted April 8, 2019 6:20pm by kevin hudson
    kevin hudson
    Pro Student 9,645 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • Harris Handoko
    Harris Handoko
    3,393 Points

    Question on order of joining tables

    Posted February 3, 2019 11:34pm by Harris Handoko
    Harris Handoko
    3,393 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    Quiz Question Issues

    Posted October 14, 2018 11:16pm by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    2 Answers

  • Fairooz Adams
    Fairooz Adams
    2,704 Points

    Quiz Question Issues

    Posted October 14, 2018 11:14pm by Fairooz Adams
    Fairooz Adams
    2,704 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points

    highest employee salary challenge

    Posted April 13, 2018 6:44pm by Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    0 Answers

  • Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points

    returning 1 row per employee

    Posted April 13, 2018 6:41pm by Olutope Ayorinde
    Olutope Ayorinde
    2,875 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    2 Answers

  • Maxine Lewis
    Maxine Lewis
    2,043 Points

    What should be added to this query to only return 1 row per employee

    Posted January 22, 2018 10:38am by Maxine Lewis
    Maxine Lewis
    2,043 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Donnie Driskell
    Donnie Driskell
    2,243 Points

    Reporting by example: 8th Grade Teachers. (my solution)

    Posted January 1, 2018 5:19am by Donnie Driskell
    Donnie Driskell
    2,243 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    2 Answers

  • Rick Garland
    Rick Garland
    2,738 Points

    MATH VALUES

    Posted December 24, 2017 12:09am by Rick Garland
    Rick Garland
    2,738 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • Bruce McMinn
    Bruce McMinn
    8,707 Points

    A different approach and learning about JOIN

    Posted August 7, 2017 8:10pm by Bruce McMinn
    Bruce McMinn
    8,707 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    3 Answers

  • Andrew Federico
    Andrew Federico
    7,483 Points

    Bug in quiz

    Posted August 4, 2017 1:58pm by Andrew Federico
    Andrew Federico
    7,483 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • György Varga
    György Varga
    19,197 Points

    Case sensitivity

    Posted July 28, 2017 6:39am by György Varga
    György Varga
    19,197 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • György Varga
    György Varga
    19,197 Points

    Wasn't the question: 'Which subjects are taught in the largest room?'

    Posted July 27, 2017 2:32pm by György Varga
    György Varga
    19,197 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    1 Answer

  • Greg Kaleka
    Greg Kaleka
    38,993 Points

    Even More Subqueries!

    Posted July 21, 2017 9:59pm by Greg Kaleka
    Greg Kaleka
    38,993 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Elective Teachers

    2 Answers

  • Greg Kaleka
    Greg Kaleka
    38,993 Points

    More Subqueries!

    Posted July 21, 2017 9:46pm by Greg Kaleka
    Greg Kaleka
    38,993 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    38,993 Points

    The Solution Provided Doesn't Work if Teachers Teach More Than One Grade

    Posted July 21, 2017 9:29pm by Greg Kaleka
    Greg Kaleka
    38,993 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    38,993 Points

    Here's a slightly more complex but more dynamic solution.

    Posted July 21, 2017 7:51pm by Greg Kaleka
    Greg Kaleka
    38,993 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • The Biggest Room

    7 Answers

  • Jackson Cromer
    Jackson Cromer
    7,548 Points

    SQL Playground Issue

    Posted July 20, 2017 5:38pm by Jackson Cromer
    Jackson Cromer
    7,548 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    4 Answers

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

Our mission is to bring affordable technology education to people everywhere in order to help them achieve their dreams and change the world.
Our Company
About Us
Contact Us
Community
Treehouse Stories
Student Perks
Treehouse Blog
Affiliate Program
Careers
Topics
HTML
CSS
Design
JavaScript
Ruby
PHP
iOS
Android
Development Tools
Business
Tracks
Web Design
Web Development
Rails Development
PHP Development
iOS Development
Android Development
Starting a Business
  • Treehouse Blog
  • About Treehouse
  • Privacy Policy
  • Terms & Conditions
  • © 2019 Treehouse Island, Inc.

Sign in

I forgot my password