Attribute DataType Description StudentID Number ID of…
Attribute DataType Description StudentID Number ID of the university student LName String Last Name DateOfBirth Date Date of birth HomeZip Number 5 digit Zip code of Home address CuGPA Number Current GPA at the university Consider the above StudentInfo table, which stores student information. The Primary Key of this table is (StudentID). All attributes will have values (in other words, none of the attributes can have NULL). Update the query below to return the student count by letter grade using the grade scale below A 4.0 A- 3.667 B 3.0 B- 2.667 C Below 2.667 For example, a student with a 3.8 GPA should have an A-. SELECT Count(StudentID) as StuCount FROM StudentInfo;
Read Details