Consider the following relations: Students Name Type Netld VARCHAR(10) FirstName VARCHAR(255) LastName VARCHAR(255) Department VARCHAR(100) Enrollments Notes and Hints: Name Type Netld VARCHAR(10) CRN INT Credits INT Score REAL • Do not use views. Courses Name CRN Title Type INT We want to nominate "STAR" students for a scholarship. STAR students are students who scored at least 90% of the highest score in a course they took. For example, if a student took 'CS101' and the highest score in this course was 99, then the student would be considered STAR if their score in 'CS101' was at least 90% of 99, i.e., 89.1. STAR students do not have to score high in all of thier courses. As long as they satisfy this criterion for at least one course, we want them on our list. VARCHAR(255) Department VARCHAR(100) Instructor VARCHAR(255) Write an SQL query that returns, for every STAR student, the student's NetId, LastName and the average Score (as AverageScore) of this student (taken across all courses that the student is enrolled in). While calculating the average score, weight the scores by the credits of the courses. That is, AverageScore = [ (Score * Credits) / Σ (Credits). Finally, ROUND AverageScore to the nearest 2 digits using a call to ROUND (???, 2). Return the results in the decreasing order of AverageScore and increasing order of NetId.