Summarizing data with outer joins?

Hey folks! I have just finished the outer joins exercise that we get on the very first time that we see it on the course. My solution looked the exact same as Mosh’s:

However, I noticed that in the real world I might also have wanted to check the total amount that each product sold. I know that I could easily do that if I just referred to the products table itself, but what if I wanted to maintain the outer join structure? Could I eliminate the duplicate entries and just have a single row with the full quantity for each product? I know it doesn’t make sense contextually, I am really just interested in the syntax and knowing whether or not I could do it.

Thanks in advance!

1 Like

That’s covered in section 5 “Summarizing Data”.

1 Like