write query sql for calculate time series analysis using lead lag and percentage of exchange of store