MySQL - 单个SQL查询中的总计数和变化率

I'm trying to extract the total number of website hits plus the rate of change(rate of increase/decrease) per client per city per day as a percentage in a single SQL query but not able to get it right. I'm trying to extract the total number of websi