I dont know how to write stored procedure for this like there are two queries involved in this as you see above so, how I am going to do this...