The following exercise will help you to improve your MS SQL server query skills effectively. I have used Microsoft SQL server 2008 R2 for the following demo
So, before starting let’s create and populate tblstudent and tblScholarship table using following script.