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
Get step-by-step solutions from verified subject matter experts
