Write SQL query to satisfy the question. Write SQL query to satisfy the question.

$5.$

$$Regardless of whether or not they are currently selling any beans, show every shop's SID and the total number of bags they sell $($if a shop currently sells no beans based on table SB$,$ the number of bags sold by that shop should appear as $0$ rather than as NULL