DataScience100Knock-S29

code: mode.sql

%%sql

select store_cd, mode() within group(order by product_cd)

from receipt

group by store_cd

order by store_cd

limit 10;