Question: You have two database tables, an orders table (left) and a customer metadata table (right). You would like to aggregate the count of orders by

You have two database tables, an orders table (left) and a customer metadata table (right).

You would like to aggregate the count of orders by gender. To achieve this, you propose to complete a database join.

Which type of join would keep all of the orders, append the gender information where available, but not lose the order data if the customer doesn't have a gender record in the customer metadata table?

a) Left Join

b) Inner Join

c) Outer Join

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!