About Question enthuware.oce-jpad.v6.2.575 :

[stiekemaj]

In my opinion, the second answer is incorrect, because the order entity is inner joined, not outer joined.
When all customers with a specific state does not have any placed orders, this state will not appear in the result. Because the question states that you want to find out the states from which customers placed orders and the number of orders for those states, I also want to see the states where there are no placed orders.

[admin]

Since the question says that you want to find out the states from which customers placed orders, it clearly implies that you don't want the states from where no order was placed. So outer join is not valid here.

[stiekemaj]

Oh, never mind You're right!