Write queries that return the following resultsets: Students are awarded two grades based on the minimum...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Based on the the grading scale specified SELECT firstname lastname CASE WHEN MINprogress 40 ... View the full answer
Related Book For
Business Analytics Communicating With Numbers
ISBN: 9781260785005
1st Edition
Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen
Posted Date:
Students also viewed these databases questions
-
(1) (a) An AISI 4340 steel plate has a width W of 30 cm and has a central crack 2 a of 3 mm. The plate is under a uniform stress. This steel has a KIc value of 50 MPa m1/2. Find the maximum stress...
-
Dr. Jenny Brown is the new CEO of a hotel chain, Hassle Free Hotel. The hotels headquarter is based in Atlanta, Georgia in the U.S. The company was established in 2004. It has a central reservation...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
1. A projectile is launched in a vertical plane, at an angle 0 with initial velocity vo. It must be caught in a frictionless circular tube of radius R in such a way that the trajectory of the...
-
If your social media monitoring efforts pick up a tweet that accuses your customer service staff of lying and claims to have evidence to back it up, how would you respond?
-
The cash records and bank statement for the month of May for Diaz Entertainment are shown below. Additional information: a. The difference in the beginning balances in the companys records and the...
-
Tasty Snack Food Company manufactures three types of snack foods: tortilla chips, potato chips, and pretzels. The company has budgeted the following costs for the upcoming period: Factory overhead is...
-
Segregation of duties is an important concept in internal control. However, segregation of duties is often a challenge for smaller businesses because they do not have sufficient staff to always...
-
A Toronto based company has to ship 26 crates of cereal dry instant to Stockholm, Sweden. Each crate weighs at 2,100 kgs. Dimension of each crate is 84 inch length, 40 inch width, and 45 inch height....
-
Roger Ginde is developing a program in supply chain management certification for managers. Ginde has listed a number of activities that must be completed before a training program of this nature...
-
How is Honig. v. Doe, 484 U.S. 484 (1988) significant to the field of education? What were the previous decisions in the Honig. v. Doe case?
-
Suppose currently Samsung's common stock is selling for $ 458 . The company announced that it will give $ 9. 1 8 dividend next year and it plans to grow the dividend by 9% every year. Given the...
-
Question 1 On 1 January 2010, Top Company purchased 30% of the 1,080,000 outstanding shares of Bottom Company for $1,300,000 The fair value of net assets of Bottom at the acquisition date totalled...
-
At visible wavelengths what is the ratio of the flux of the full Earth as seen from the Moon to the flux of the full Moon as seen from the Earth? Discuss.
-
To join an upscale country club, an individual must first purchase a membership bond for $20,000. Inaddition, monthly membership dues are $200. Suppose an individual want to put aside a lump sum of...
-
You have an opportunity to invest $ 1 0 5 0 0 0 now in return for $ 7 9 5 0 0 in one year and $ 2 9 2 0 0 in two years. If your cost of capital is 8 . 9 % , what is the NPV of this investment?
-
You must conduct extensive online research to find at least five recent examples of your chosen product's or service's communication mix, including traditional elements and digital platforms. The...
-
If M = 7, s = 2, and X = 9.5, what is z?
-
The accompanying file contains four observations with four categorical variables, x 1 , x 2 , x 3 , and x 4 . a. Compute the matching coefficient for all pairwise observations. b. Identify the pair...
-
Sunnyville Bank wants to identify customers who may be interested in its new mobile banking app. The worksheet called Mobile_Banking_Data contains 500 customer records collected from a previous...
-
Answer the following questions using the accompanying data set that lists the actual class memberships and predicted Class 1 (target class) probabilities for 10 observations. a. Compute the...
-
Gemini manufactures athletic shoes. The company records manufacturing costs by job number and uses a factory overhead applied rate to charge overhead costs to its products. The company estimates...
-
Century Fan Company manufactures ceiling fans. During the current year, payments were made for the following items. A new clerk classified the cost items. Are the cost items classified correctly? If...
-
Sea Explor manufactures deep-sea diving suits. The company records manufacturing costs by job number and uses a factory overhead applied rate to charge overhead costs to its products. Sea Explor...
Study smarter with the SolutionInn App