Generate SQL code to make a report which will do the following Generate a concatenated class...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Generate SQL code to make a report which will do the following Generate a concatenated class name/number string, such as "FIN 200" from something in the Finance Department where the course number is 200 Print that class name/number string in the first column of your report Print the class description (such as "Introduction to Finance") List the student's first name and then last name List the offering term and the format (online or in person) List the professor's first name and last name Sort your output ascending by the class name/number string, so "FIN 200", "FIN 120" and "ART 100" would be sorted in the following order: "ART 100", "FIN 120", "FIN 200." Within the same class, further sort your output so it's alphabetical by student last name, student first name Professor Victoria Emmerline is set to retire immediately before spring semester. You want to generate a list of all students who are currently enrolled in any class she is teaching this spring, so you can reach out to them and let them know there will be a different professor. Assume each class she teaches could be assigned to a different professor - i.e. if Professor Emmerline was set to teach Calculus I and Calculus II, it's possible Calculus I will be assigned to Professor X and Calculus II will be assigned to Professor Y. Generate SQL code to make a report which will do the following Generate a concatenated class name/number string, such as "FIN 200" from something in the Finance Department where the course number is 200 Print that class name/number string in the first column of your report Print the class description (such as "Introduction to Finance") List the student's first name and then last name List the offering term and the format (online or in person) List the professor's first name and last name Sort your output ascending by the class name/number string, so "FIN 200", "FIN 120" and "ART 100" would be sorted in the following order: "ART 100", "FIN 120", "FIN 200." Within the same class, further sort your output so it's alphabetical by student last name, student first name Professor Victoria Emmerline is set to retire immediately before spring semester. You want to generate a list of all students who are currently enrolled in any class she is teaching this spring, so you can reach out to them and let them know there will be a different professor. Assume each class she teaches could be assigned to a different professor - i.e. if Professor Emmerline was set to teach Calculus I and Calculus II, it's possible Calculus I will be assigned to Professor X and Calculus II will be assigned to Professor Y.
Expert Answer:
Answer rating: 100% (QA)
Generate SQL code to make a report which will do the following Generate a concatenated class namenum... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
What are the strategic implications of team psychological safety in promoting risk-taking, innovation, and knowledge sharing, and how can leaders cultivate a psychologically safe climate within their...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Do laws provide a complete guide to ethical behavior? Can an activity be legal but not ethical?
-
Take nitrogen to be a van der Waals gas with a = 1.352 dm6 atm mol-2 and b = 0.0387 dm3 mol-1, and calculate Hm when the pressure on the gas is decreased from 500 atm to 1.00 atm at 300 K. For a van...
-
What mass of AgI can be produced from a 0.512-g sample that assays 20.1% AlI3?
-
The table below reports the unemployment rate, labor force participation rate, and (working-age) population for the United States in January 2008, 2011, and 2016. Using the data, answer the following...
-
The following expenditures relating to plant assets were made by Devereaux Company during the first 2 months of 2014. 1. Paid $5,000 of accrued taxes at time plant site was acquired. 2. Paid $400...
-
Read the following CBC News article titled "Stobbe's lawyer highlights unknown DNA in defence". Pretend you are a juror hearing this information for the first time, and in a well-developed paragraph...
-
10. Classifying Processed Images into Multiple Classes Introduction We have processed images to represent as a vector of 300 attributes. The first 294 are decimal values in the range 0 to 1...
-
AIM 2.6: Define time class with hour and minute. Also define addition method to add two time objects.
-
You work for a company that manufactures heavy machinery. A construction company is interested in your excavators but it is taking several meetings and multiple evaluations before any purchase can be...
-
Discuss the anatomical adaptations of the respiratory system in response to environmental factors, such as altitude or chronic exposure to pollutants.
-
Webster University decides to convert from a non-profit educational institution to a for-profit public corporation. It has an initial public offering and begins trading as a public company with a...
-
6. Using Distance-Vector algorithm, show the minimum distance table entries of routers A, B, C and D in the following figure. (15 Points) 2 A 2 D 5 C 3 4 B
-
Examine the anatomical features of the digestive system that contribute to the efficient digestion and absorption of nutrients, integrating aspects of gastrointestinal motility and enzyme secretion.
-
Write short notes on ANY TWO of the following: (i) Capacitor-start motor. (ii) (iii) Switched reluctance motor. Stepper motor.
-
Suppose that the laptop of Prob. 2.16 is placed in an insulating briefcase with a fully charged battery, but it does not go into sleep mode, and the battery discharges as if the laptop were in use....
-
Sherry Hopson owns a retail family clothing store. Her store is located at 4321 Circle Drive, Houston, TX 77001. Her employer identification number is 95- 1234321 and her Social Security number is...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1 and 2. On September 1, Irene opened a retail store that specializes in sports car...
-
Diego, age 28, married Dolores, age 27, in 2012. Their salaries for the year amounted to $46,479 and they had interest income of $3,500. Diego and Dolores' deductions for adjusted gross income...
-
Why are none of the bulbs in Figure 31. 24 lit? Data from Figure 31. 24 Figure 31.24 (1) (iii) NNN
-
In Figure 31. 25, identify the energy conversions that occur between points \(A\) and \(B, B\) and \(\mathrm{C}, \mathrm{C}\) and \(\mathrm{D}\), and \(\mathrm{D}\) and \(\mathrm{A}\). Data from...
-
In Figure 31. 26, bulb B is brighter than bulb C, which in turn is brighter than bulb A. Rank, largest first, \((a)\) the magnitudes of the potential differences across the bulbs, \((b)\) the...
Study smarter with the SolutionInn App