write a query to find city which had lowest percentage spend for gold card typeĥ. It reaches a cumulative of 1000000 total spends(We should have 4 rows in the o/p one for each card type)Ĥ. write a query to print the transaction details(all columns from the table) for each card type when
write a query to print highest spend month and amount spent in that month for each card typeģ. write a query to print top 5 cities with highest spends and their percentage contribution of total credit card spendsĢ. Import the dataset in PostgreSQL or any SQL platform with table name: credit_card_transcationsġ. Just finished with Data Analyst- Credit Card Spending Habits in India Case Study, provided sharing my solution as well for the SQL case study.ĭownload credit card transactions dataset from below link: Here is a very interesting Data Analyst case study to check my SQL knowledge.
