Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL Problem Template
--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
Rno 37 boat
Sql flight 1
Demo
Show slowest queries
BRYAN_BD Actul
Rno 37 boat 2
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
Consecutive publisher publish more than 2 books for 3 days
BRYAN_BD
tableA