Question

Return a list of all the first and last names and house of people who are in Gryffindor. You should use a JOIN to combine a person with the name of their house. To be clear, make the columns in the final result be "first_name", "last_name", "house" Sort alphabetically by first name.

Name: return a list of all the first and last names and house of people who are in gryffindor you should use a join to combine a person with the name of their house to be clear make the columns in the final
Uploaded: 2023-11-28T21:16:40-08:00
Duration: 5 min 11 s
Channel: Willis James
Description: return a list of all the first and last names and house of people who are in gryffindor you should use a join to combine a person with the name of their house to be clear make the columns in the final

          Return a list of all the first and last names and house of people who are in Gryffindor.  You should use a JOIN to combine a person with the name of their house.  To be clear, make the columns in the final result be "first_name", "last_name", "house"  Sort alphabetically by first name.

Added by Jeremie T.

Biochemistry

Mary K. Campbell, Shawn O. Farrell 8th Edition

Chapter 1

Instant Answer

Solved by Expert Willis James

11/28/2023

Step 1

Typically, you will have a `people` table that contains information about individuals, including their first and last names, and a `houses` table that contains information about the houses, including the house name. Show more…

Show all steps

Thanks for your feedback!

Return a list of all the first and last names and house of people who are in Gryffindor. You should use a JOIN to combine a person with the name of their house. To be clear, make the columns in the final result be "first_name", "last_name", "house" Sort alphabetically by first name.