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.
1 2 3 4 5 6 7 8 9 | Create table tblStudent ( StudentId int, FirstName varchar(50), LastName varchar(50), Admission_fee int, Admission_date datetime, Branch varchar(50), ) |
1 2 3 4 5 6 | Create table tblScholarship ( Student_ref_id int, Scholarship_Date date, Scholarship_Amount int ) |
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 |
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 |
20 December 20192396 Written By: Rohit
© 2020 Tech Study. All rights reserved | Developed by Tech Study| Privacy Policy | Sitemap