Question: using joins in SQL help with questions 9-12 thanks For questions 9- 12, use the following two tables. Assume each shape can only have one

using joins in SQL help with questions 9-12
thanks
 using joins in SQL help with questions 9-12 thanks For questions

For questions 9- 12, use the following two tables. Assume each shape can only have one color i.e. this is not a many-to-many relationship. IMPORTANT NOTE: Questions 9-11 are ALL OR NOTHING. You either get them exactly correct or they are worth 0 points Colors Shapes color_id color shape_id color_id shape Red Blue Orange Green Square Circle Star Triangle 4 (12 points) Name all the color and shape combos (e.g. purple hexagon, teal decagon) the following query would produce: SELECT c.color, s.shape FROM colors AS c JOIN shapes AS S ON c.color id s.color id; Color/ shape combos: 0. (12 points) Name only the colors that would appear in the following query SELECT c.color FROM colors AS C LEFT JOIN shapes AS s ON c.color id s.color id: Colors: (12 points) Name only the colors that would appear in the following query SELECT e.color FROM shapes AS S RIGHT JOIN colors ASc ON s.color id c.color id Colors: 12. (10 points) Using colors as the left table and shapes as the right table, would a LEFT JOIN and a FULL OUTER JOIN produce different results? Why or why not

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!