• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Content Library
  • Community
  • Support
  • Jobs
    • 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
  • Rushabha Jain
    seal-mask
    PLUS
    .a{fill-rule:evenodd;}techdegree
    Rushabha Jain
    Front End Web Development Techdegree Student 9,859 Points

    cte vs join performance

    Posted April 18, 2021 7:01am by Rushabha Jain
    .a{fill-rule:evenodd;}techdegree
    Rushabha Jain
    Front End Web Development Techdegree Student 9,859 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Jordan young
    PLUS
    Jordan young
    Courses Plus Student 5,251 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,251 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Michael Hill
    Michael Hill
    3,960 Points

    My Solution to this Challenge

    Posted May 17, 2020 5:13pm by Michael Hill
    Michael Hill
    3,960 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

    3 Answers

  • Ronald Greer
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Ronald Greer
    Front End Web Development Techdegree Graduate 56,280 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
    .a{fill-rule:evenodd;}techdegree seal-36
    Ronald Greer
    Front End Web Development Techdegree Graduate 56,280 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • Day 1: Review

    1 Answer

  • kevin hudson
    PLUS
    kevin hudson
    Courses Plus Student 11,578 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 11,578 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • Harris Handoko
    Harris Handoko
    3,932 Points

    Question on order of joining tables

    Posted February 3, 2019 11:34pm by Harris Handoko
    Harris Handoko
    3,932 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

    3 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

    1 Answer

  • 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,029 Points

    A different approach and learning about JOIN

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

    4 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,018 Points

    Even More Subqueries!

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

    2 Answers

  • Greg Kaleka
    Greg Kaleka
    39,018 Points

    More Subqueries!

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

    4 Answers

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

    4 Answers

  • Greg Kaleka
    Greg Kaleka
    39,018 Points

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

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

  • 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

  • Perks
  • Treehouse for Libraries
  • Treehouse for Teams
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2022 Treehouse Island, Inc.