Questions to analyze.txt

Questions :


1- write a query to print top 5 cities with highest spends and their percentage contribution of total credit card spends 

2- write a query to print highest spend month and amount spent in that month for each card type

3- write a query to print the transaction details(all columns from the table) for each card type when
it reaches a cumulative of 1000000 total spends(We should have 4 rows in the o/p one for each card type)

4- write a query to find city which had lowest percentage spend for gold card type

5- write a query to print 3 columns:  city, Highest_expense_type , Lowest_expense_type (example format : Delhi , bills, Fuel)

6- write a query to find percentage contribution of spends by females for each expense type

7- which card and expense type combination saw highest month over month growth in Jan-2014

8- during weekends which city has highest total spend to total no of transactions ratio 

9- which city took least number of days to reach its 500th transaction after the first transaction in that city