• Kindly reply complete solution . Also note i am using SQL 2012