Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
practice sql_12AUG
Update using a temp table
SQL2
FIGURA5.4
Split name
/Users/svetlanakanevskaa/Downloads/ACDB_LIGHT_MS.sql
hhhhhhhhhhh
Task_3_FInal
Stuff code in sql
db