SQL Server Advanced Questions – ‘Join’

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.

Create table tblStudent
(
    StudentId int,
    FirstName varchar(50),
    LastName varchar(50),
    Admission_fee int,
    Admission_date datetime,
    Branch varchar(50),
)

Create table tblScholarship
(
    Student_ref_id int,
    Scholarship_Date date,
    Scholarship_Amount int
)

 tblstudent