Here are the solutions for SQL Programming Code Challenge which are asked in cognizant. Note:…