TEST 2, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

create table StudentCourses (
    FirstName  nvarchar(50),
    LastName   nvarchar(50),
    CourseCode nvarchar(6),
    CourseName nvarchar(50),
    GradeScore decimal(10, 2));

insert into StudentCourses (FirstName, LastName, CourseCode, CourseName, GradeScore)
values('Charles', 'Babbage', 'COM001', 'Computer Science I', 70.25);

insert into StudentCourses (FirstName, LastName, CourseCode, CourseName, GradeScore)
values('Charles', 'Babbage', 'COM002', 'Computer Science II', 67.65);

insert into StudentCourses (FirstName, LastName, CourseCode, CourseName, GradeScore)
values('Charles', 'Babbage', 'COM003', 'Computer Science III', 81.5);

insert into StudentCourses (FirstName, LastName, CourseCode, CourseName, GradeScore)
values('Alan', 'Turing', 'COM001', 'Computer Science I', 77.25);

insert into StudentCourses (FirstName, LastName, CourseCode, CourseName, GradeScore)
values('Alan', 'Turing', 'COM002', 'Computer Science II', 90.65);

insert into StudentCourses (FirstName, LastName, CourseCode, CourseName, GradeScore)
values('Alan', 'Turing', 'COM003', 'Computer Science III', 99.5);

select * 
from StudentCourses

-- 1. Fix the table structure
-- 2. Create a query that gets the grade average for all students
-- 3. Create a query that determines the top scoring student for COM003

View schema
Execution time: 0,02 sec, rows selected: 7, rows affected: 6, absolute service time: 0,17 sec, absolute service time: 0,18 sec