• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Library
  • Community
  • Support
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
  • Jordan young
    PLUS
    Jordan young
    Courses Plus Student 5,024 Points

    Hi. I did a totally different query, but generated the same result. Is there a preference for either method?

    Posted September 24, 2020 3:02pm by Jordan young
    Jordan young
    Courses Plus Student 5,024 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Michael Hill
    Michael Hill
    3,882 Points

    My Solution to this Challenge

    Posted May 17, 2020 5:13pm by Michael Hill
    Michael Hill
    3,882 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    1 Answer

  • Frances Angulo
    Frances Angulo
    5,311 Points

    My solution returned more results

    Posted January 25, 2020 4:02pm by Frances Angulo
    Frances Angulo
    5,311 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    2 Answers

  • Ronald Greer
    Ronald Greer
    45,063 Points

    I thought that the answer to the first fill in the blank was "* FROM". what am i doing wrong?

    Posted December 29, 2019 4:00pm by Ronald Greer
    Ronald Greer
    45,063 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • kevin hudson
    PLUS
    kevin hudson
    Courses Plus Student 9,655 Points

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

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

    2 Answers

  • Harris Handoko
    Harris Handoko
    3,394 Points

    Question on order of joining tables

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

    2 Answers

  • 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
    10,026 Points

    A different approach and learning about JOIN

    Posted August 7, 2017 8:10pm by Bruce McMinn
    Bruce McMinn
    10,026 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,198 Points

    Case sensitivity

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

    2 Answers

  • György Varga
    György Varga
    19,198 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,198 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Subjects in the Big Room

    1 Answer

  • Greg Kaleka
    Greg Kaleka
    39,007 Points

    Even More Subqueries!

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

    2 Answers

  • Greg Kaleka
    Greg Kaleka
    39,007 Points

    More Subqueries!

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

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    39,007 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
    39,007 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 8th Grade Teachers

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    39,007 Points

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

    Posted July 21, 2017 7:51pm by Greg Kaleka
    Greg Kaleka
    39,007 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.

Treehouse Logo
Our mission is to bring affordable technology education to people everywhere in order to help them achieve their dreams and change the world.
Company
Careers
Contact
Library
Tracks
Community
Stories
Perks
Affiliate Program
Treehouse for Libraries
Topics
HTML
CSS
Design
JavaScript
Ruby
View all 24 Topics
Tracks
Front End Web Development
Full Stack JavaScript
Beginning Python
UX: Interaction Design
Digital Literacy
View all 42 Tracks
  • Twitter
  • YouTube
  • FaceBook
  • LinkedIn
  • Instagram
  • About Treehouse
  • Blog
  • Shop
  • Privacy Policy
  • Terms & Conditions
  • © 2020 Treehouse Island, Inc.