Design SQL/Pandas aggregations on retail schema | Amazon SQL Question