Write queries that return the following resultsets: Students are awarded two grades based on the minimum...

Transcribed Image Text:

Write queries that return the following resultsets: Students are awarded two grades based on the minimum and maximum progress they are making in their courses. The grading scale is as follows: Progress < 40: Progress < 50: Progress < 60: Progress < 70: B Progress >= 70: A Write a query that displays each student's First Name, Last Name, Minimum Grade based on their minimum progress, and Maximum Grade based on their maximum progress. The output should be sorted by Minimum Grade in descending order, then by Maximum Grade in descending order, then by First Name in ascending order, then by Last Name in ascending order 200 College Management System Schema department id name faculty id F D Column Name firstname lastname deptid C student city state Column Name id firstname lastname street streetDetail Column Name postalCode majorld Data Type int varchar(30) Data Type int varchar(30) varchar(50) int Data Type int varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int Allow Nulls 000 Allow Nulls OOOOO Allow Nulls OOOOOOOOO ko course id Column Name name deptid studentCourse Column Name studentid courseld progress startDate facultyCourse Column Name oc facultyld courseld int varchar(50) int Data Type int int int date int int Data Type Data Type Allow Nulls oooo Allow Nulls ooooo 0 Allow Nulls 000 Write queries that return the following resultsets: Students are awarded two grades based on the minimum and maximum progress they are making in their courses. The grading scale is as follows: Progress < 40: Progress < 50: Progress < 60: Progress < 70: B Progress >= 70: A Write a query that displays each student's First Name, Last Name, Minimum Grade based on their minimum progress, and Maximum Grade based on their maximum progress. The output should be sorted by Minimum Grade in descending order, then by Maximum Grade in descending order, then by First Name in ascending order, then by Last Name in ascending order 200 College Management System Schema department id name faculty id F D Column Name firstname lastname deptid C student city state Column Name id firstname lastname street streetDetail Column Name postalCode majorld Data Type int varchar(30) Data Type int varchar(30) varchar(50) int Data Type int varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int Allow Nulls 000 Allow Nulls OOOOO Allow Nulls OOOOOOOOO ko course id Column Name name deptid studentCourse Column Name studentid courseld progress startDate facultyCourse Column Name ocfacultyld courseld int varchar(50) int Data Type int int int date int int Data Type Data Type Allow Nulls oooo Allow Nulls ooooo 0 Allow Nulls 000 Write queries that return the following resultsets: Students are awarded two grades based on the minimum and maximum progress they are making in their courses. The grading scale is as follows: Progress < 40: Progress < 50: Progress < 60: Progress < 70: B Progress >= 70: A Write a query that displays each student's First Name, Last Name, Minimum Grade based on their minimum progress, and Maximum Grade based on their maximum progress. The output should be sorted by Minimum Grade in descending order, then by Maximum Grade in descending order, then by First Name in ascending order, then by Last Name in ascending order 200 College Management System Schema department id name faculty id F D Column Name firstname lastname deptid C student city state Column Name id firstname lastname street streetDetail Column Name postalCode majorld Data Type int varchar(30) Data Type int varchar(30) varchar(50) int Data Type int varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int Allow Nulls 000 Allow Nulls OOOOO Allow Nulls OOOOOOOOO ko course id Column Name name deptid studentCourse Column Name studentid courseld progress startDate facultyCourse Column Name oc facultyld courseld int varchar(50) int Data Type int int int date int int Data Type Data Type Allow Nulls oooo Allow Nulls ooooo 0 Allow Nulls 000 Write queries that return the following resultsets: Students are awarded two grades based on the minimum and maximum progress they are making in their courses. The grading scale is as follows: Progress < 40: Progress < 50: Progress < 60: Progress < 70: B Progress >= 70: A Write a query that displays each student's First Name, Last Name, Minimum Grade based on their minimum progress, and Maximum Grade based on their maximum progress. The output should be sorted by Minimum Grade in descending order, then by Maximum Grade in descending order, then by First Name in ascending order, then by Last Name in ascending order 200 College Management System Schema department id name faculty id F D Column Name firstname lastname deptid C student city state Column Name id firstname lastname street streetDetail Column Name postalCode majorld Data Type int varchar(30) Data Type int varchar(30) varchar(50) int Data Type int varchar(30) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) char(5) int Allow Nulls 000 Allow Nulls OOOOO Allow Nulls OOOOOOOOO ko course id Column Name name deptid studentCourse Column Name studentid courseld progress startDate facultyCourse Column Name ocfacultyld courseld int varchar(50) int Data Type int int int date int int Data Type Data Type Allow Nulls oooo Allow Nulls ooooo 0 Allow Nulls 000

Answer rating: 100% (QA)

Based on the the grading scale specified SELECT firstname lastname CASE WHEN MINprogress 40 ... View the full answer