Microsoft SQL Server Level 1 Excercises

 Dear Readers,Here i have provided the Level 1 Exercises of Microsoft SQL Server course.Please go through the exercises and practice well.If you have any queries on the same.Please do comment on the same.I have added few interview questions in the my previous articles along with the specific topics which are related to the SQL Server.

1.Declare a three variables a,b,c perform the division operation using sql server
E.G : c=a/b;(Print the output like 'Division of A and B is '+c)

2. SELECT 10 + 15 - 5 * 2;Justify the answer why it is 15 not 30 ?

3.Understand the concept of BODMAS / PEMDAS and the order of expression evaluation

4.Implement a simple interest and compound interest formula using SQL Server
P-Principal
R-Rate of Interest in %
T-Time Period
Simple Interest Formula
SI=(P*R*I)/100
Compound Interest Formula
CI=P*Power(1+(R/100)t)

5.What is the result of below expression NULL+100
Is It Null Or 100.Justify your explanation




6.Implement a SQL Program to extract last 2 digits a given number
E.G:798
O/p:98

7.Implement a SQL Program which should accept 5 subjects marks find the
calculate the sum and average of the marks

8.Create a Branch table with respective columns

Create a student table with the following columns Id,Name,Branch,Age,Email,MobileNo,YearOfStudy,DateOfJoin,Percentage,IsActive,CreatedOn,CreatedBy, ModifiedOn, ModifiedBy apply all constraints i.e., primarykey,not null,unique,default,check and foreign key constraint


Implement a following queries based on the above table







9.Fill the data in to the table and fill some null values into Percentage columns as well as add data into the department tables

10.Implement a query of Update a percentage with +1 in the student table.

11. Implement a query of delete whose percentage values has  -ve in values

12.Implement a Sql query to fetch the students of CSE and ECE branch students

13. Implement a Sql query to find the 1,3,5,8,9 id values data of a student's tables

14.Implement a sql query create a column of Grade in students table
If Percentage >90 A+
If Percentage >80 and  Percentage <90 A
If Percentage >70 and  Percentage <80 B+
If Percentage >60 and  Percentage <70 B
If Percentage >50 and  Percentage <60 C
If Percentage <50   D

15.Implement a Sql query to find the 'D' Grade students

16.Implement a Sql query to find the distinct branch from the student tables

17.Implement a Sql query to display the percentage wise ascending and name wise descending students data

18.Implement a sql query to find the academic percentage range from 50 to 100

19.Implement a sql query to find the branch wise students count 

20.Implement a data retrieval using any keyword

21.Implement a data retrieval using all keyword

22.Insert a student name like below
 Veere%ndra
Implement a sql query to retrieve the whose name contains % symbol.

23.Implement a sql query to display the branch wise count of students whose count is greater than 5

24.Implement a sql query to find the most recent branch opted by the student w.r.t to the students table

25.Implement a sql query find the students list whose DOJ falls in the year of 2021