Amazon CSV sqlite3 playing

gistfile1.txt

$ sqlite3
sqlite> .mode csv
sqlite> .import brad-2016-2020.csv items
sqlite> .import brad-2021-ytd.csv items
sqlite> .mode column
sqlite> .width 40
sqlite> .header on
sqlite> CREATE VIEW money_cat AS select Category, sum(Cast(Ltrim("Item Total", "$") as decimal)) as "Sum", count(*) from items group by Category;
sqlite> select category, round(100 * sum / (select sum(sum) from money_cat), 2) as "percent", "count(*)" from money_cat order by 2 desc limit 50;
Category                                  percent     count(*)  
----------------------------------------  ----------  ----------
COMPUTER_DRIVE_OR_STORAGE                 19.15       21        
ELECTRONIC_SWITCH                         8.57        30        
TELEVISION                                6.46        2         
SECURITY_CAMERA                           5.86        9         
ELECTRONIC_CABLE                          3.23        45        
COMPUTER_INPUT_DEVICE                     3.19        7         
NETWORKING_DEVICE                         3.19        10        
HOME_LIGHTING_ACCESSORY                   2.96        21        
BUILDING_MATERIAL                         2.91        5         
                                          2.72        18        
POWER_SUPPLIES_OR_PROTECTION              2.69        3         
OUTDOOR_LIVING                            1.71        16        
NETWORKING_ROUTER                         1.55        4         
SPORT_HELMET                              1.48        1         
MONITOR                                   1.27        4         
PERSONAL_COMPUTER                         1.27        6         
PRINTER                                   1.11        1         
GAS_SMOKE_FIRE_ALARM                      1.1         2         
SYSTEM_POWER_DEVICE                       1.09        6         
SPORTING_GOODS                            1.08        8         
STORAGE_BOX                               0.95        6         
COMPUTER_COMPONENT                        0.86        7         
MOTHERBOARD                               0.84        4         
KITCHEN                                   0.79        5         
SURVIVAL_KIT                              0.79        2         
COMPUTER_PROCESSOR                        0.78        1         
ROBOTIC_VACUUM_CLEANER                    0.75        1         
TABLE                                     0.74        3         
HEADPHONES                                0.71        2         
ABIS_BOOK                                 0.6         18        
SURVEILANCE_SYSTEMS                       0.59        3         
HARDWARE                                  0.58        7         
BATTERY                                   0.49        15        
CHARGING_ADAPTER                          0.49        7         
ELECTRONIC_DEVICE_DOCKING_STATION         0.47        1         
BED                                       0.44        1         
LADDER                                    0.44        1         
POOL_SPA_WATER_TREATMENT                  0.44        3         
TOYS_AND_GAMES                            0.43        11        
CHAINSAW                                  0.41        1         
TOOLS                                     0.41        8         
FLASH_MEMORY                              0.39        6         
FIRE_PIT                                  0.37        1         
PORTABLE_STOVE                            0.37        1         
NETWORK_INTERFACE_CONTROLLER_ADAPTER      0.36        5         
OUTDOOR_RECREATION_PRODUCT                0.36        3         
VIDEO_CARD                                0.34        2         
LIGHT_BULB                                0.33        8         
STORAGE_RACK                              0.33        2         
LOCK                                      0.32        1         

sqlite> select category, count(*) from items group by 1 order by 2 desc limit 100;
Category                                  count(*)  
----------------------------------------  ----------
ELECTRONIC_CABLE                          45        
ELECTRONIC_SWITCH                         30        
COMPUTER_DRIVE_OR_STORAGE                 21        
HOME_LIGHTING_ACCESSORY                   21        
                                          18        
ABIS_BOOK                                 18        
OUTDOOR_LIVING                            16        
BATTERY                                   15        
TOYS_AND_GAMES                            11        
NETWORKING_DEVICE                         10        
SECURITY_CAMERA                           9         
ELECTRONIC_ADAPTER                        8         
LIGHT_BULB                                8         
NON_RIDING_TOY_VEHICLE                    8         
SPORTING_GOODS                            8         
TOOLS                                     8         
BABY_PRODUCT                              7         
CHARGING_ADAPTER                          7         
COMPUTER_COMPONENT                        7         
COMPUTER_INPUT_DEVICE                     7         
HARDWARE                                  7         
FLASH_MEMORY                              6         
PERSONAL_COMPUTER                         6         
STORAGE_BOX                               6         
SYSTEM_POWER_DEVICE                       6         
BOARD_GAME                                5         
BUILDING_MATERIAL                         5         
KITCHEN                                   5         
NETWORK_INTERFACE_CONTROLLER_ADAPTER      5         
ADHESIVE_TAPES                            4         
AUTO_ACCESSORY                            4         
MONITOR                                   4         
MOTHERBOARD                               4         
NETWORKING_ROUTER                         4         
PORTABLE_ELECTRONIC_DEVICE_COVER          4         
POWER_CORD                                4         
ADHESIVES_AND_SEALANTS                    3         
BODY_DEODORANT                            3         
CE_ACCESSORY                              3         
COFFEE_MAKER                              3         
COMPUTER_ADD_ON                           3         
COMPUTER_CHASSIS                          3         
DISHWASHER_DETERGENT                      3         
ELECTRONIC_WIRE                           3         
HEALTH_PERSONAL_CARE                      3         
OUTDOOR_RECREATION_PRODUCT                3         
PHONE_ACCESSORY                           3         
PLUMBING_FIXTURE                          3         
POOL_SPA_WATER_TREATMENT                  3         
POWER_SUPPLIES_OR_PROTECTION              3         
SAFETY_SUPPLY                             3         
SURVEILANCE_SYSTEMS                       3         
TABLE                                     3         
WALL_ART                                  3         
ART_AND_CRAFT_SUPPLY                      2         
AV_FURNITURE                              2         
BEARINGS_AND_BUSHINGS                     2         
BOOKS_1973_AND_LATER                      2         
BUCKET                                    2         
CELLULAR_PHONE_CASE                       2         
COFFEE_FILTER                             2         
CONSUMER_ELECTRONICS                      2         
ELECTRONIC_COMPONENT_FAN                  2         
FAUCET                                    2         
FLAT_SCREEN_DISPLAY_MOUNT                 2         
GAS_SMOKE_FIRE_ALARM                      2         
HARDWARE_TUBING                           2         
HEADPHONES                                2         
HVAC_AIR_FILTER                           2         
INCONTINENCE_PROTECTOR                    2         
KEYBOARDS                                 2         
MEDICATION                                2         
REMOTE_CONTROL                            2         
RUG_PAD                                   2         
SAFE                                      2         
SCREWS                                    2         
SHIPPING_BOX                              2         
SOUND_AND_RECORDING_EQUIPMENT             2         
SPEAKERS                                  2         
STORAGE_RACK                              2         
SURVIVAL_KIT                              2         
TELEVISION                                2         
TERMINAL_BLOCK                            2         
TOOTH_CLEANING_AGENT                      2         
TOWEL_HOLDER                              2         
VACUUM_FILTER                             2         
VIDEO_CARD                                2         
WIRELESS_ACCESSORY                        2         
AIR_PUMP                                  1         
APPAREL_PIN                               1         
APRON                                     1         
ARTIFICIAL_TREE                           1         
AV_RECEIVER                               1         
BABY_CARRIER                              1         
BEAUTY                                    1         
BED                                       1         
BED_FRAME                                 1         
BED_LINEN_SET                             1         
BOTTLE                                    1         
CABINET                                   1