Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
TEST 2
--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
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
BC3TOSQL
Task_7_Final
islands and gaps problem
Status History
DETAILS
hhhhhhhhhhh
Create Index On Viiew
TRIGGERS
Jean
kuy09:admin09@pkms99.info
Please log in to post a comment.