super_case_study

-- List of all chargeback reasons
SELECT DISTINCT REASON 
FROM 'data_cb_sheet1.csv';

-- Calculate the 'fraud' reason count and the dollar sum of all 'fraud' 
SELECT COUNT(*) AS count, ROUND(SUM(AMOUNT_DISPUTED),2) AS dollar_amount
FROM 'data_cb_sheet1.csv'
WHERE REASON = 'fraud'

-- the top 5 cities for fraud chargebacks
SELECT HOTEL_CITY, REASON, SUM(AMOUNT_DISPUTED) AS AMOUNT_DISPUTED_SUM
FROM 'data_cb_sheet1.csv'
WHERE REASON = 'fraud'
GROUP BY HOTEL_CITY, REASON
ORDER BY AMOUNT_DISPUTED_SUM DESC
LIMIT 5;