Duplicates! The scourge of every data engineer. Our sales data today has a couple of them. Your job is to read the data from an external stage, and clean it up. Expunge the duplicates using GROUP BY ALL that shiney new SQL command we’ve all been given.
Start Up Code
create or replace stage week55_stage
url='s3://frostyfridaychallenges/challenge_55/';
At the end your data should look like:

Remember, if you want to participate:
Another nice challenge to demonstrate new functionality, thanks!
Lovely feature!
Thanks for the challenge! This will be useful with SELECT ILIKE