Unable to get the solution for few questions case study 2

Please revert to the query with some response, as ima waiting for the submission of the same to move on to the net task.