Question: Table GradeDistribution illustrates how coursework grades are distributed for COP 4 7 0 3 . ReqID is an ID provided for each requirement. ReqName is
Table GradeDistribution illustrates how coursework grades are distributed for COP ReqID is an ID provided for each requirement. ReqName is the name of the requirement, which is a maximum of characteres. NumOfItems shows the number of tasks for each requirement. Points is the grades associated with each task.
GradeDistribution
From table GradeDistribution, write SQL queries to find the following:
How many requirements have points greater than
Which requirements requirement names start with the letter F
Write an SQL statement to create table GradeDistribution
Using ONE query, correct the names of ALL exam requirements such that:
Final Exam becomes: Exam
Midterm Exam becomes: Exam
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
