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

StudentId	FirstName	LastName	Admission_fee	Admission_date	Branch
1	John	Smith	1000	2018-06-10	Computer Engineering
2	David	Jones	1200	2018-06-20	Civil Engineering
3	Michael	Johnson	900	2018-08-15	Chemical Engineering
4	Chris	Lee	1500	2018-07-10	Electrical Engineering
5	Mike	Brown	1600	2018-09-10	Mechanical Engineering
6	Lisa	Smith	1800	2018-07-10	Computer Engineering
7	Mary	Smith	1600	2018-06-11	Computer Engineering

- tblScholarship

Student_ref_id	Scholarship_Date	Scholarship_Amount
1	2018-10-09	100
2	2018-11-10	150
3	2018-12-12	200
4	2019-01-05	100
5	2019-02-25	150
6	2019-03-15	NULL
7	2019-04-23	110

Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn't get Scolarship

20 December 20192713 Written By: Rohit

SQL Server Advanced Questions - 'Join'

- tblstudent

- tblScholarship

Related Topics

Popular Posts

About Us

Subscribe