Reference no: EM131057935
Write the following queries in SQL, using the university schema. (We suggest you actually run these queries on a database, using the sample data that we provide on the Web site of the book, db-book.com. Instructions for setting up a database, and loading sample data, are provided on the above Web site.)
a. Find the titles of courses in the Comp. Sci. department that have 3 credits.
b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.
c. Find the highest salary of any instructor.
d. Find all instructors earning the highest salary (there may be more than one with the same salary).
e. Find the enrollment of each section that was offered in Autumn 2009.
f. Find the maximum enrollment, across all sections, in Autumn 2009.
g. Find the sections that had the maximum enrollment in Autumn 2009
|
Find the id and the grade-point average of every student
: Find the grade-point average (GPA) for the above student, that is, the total grade-points divided by the total credits for the associated courses.
|
|
Use the payback decision rule to evaluate this project
: Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 7 percent, and that the maximum allowable payback and discounted payback statistics for the pr..
|
|
Price of a child ticket and a senior ticket
: The first day she sold 4 senior citizen tickets and 2 children's tickets for a total of $80.00. The 2nd day she received $145.00 for 5 senior citizen tickets and 7 children's tickets. What is the price of a child's ticket and a senior ticket?
|
|
The cart wheel plans to pay an annual dividend
: The Cart Wheel plans to pay an annual dividend of $1.20 per share next year, $1.00 per share a year for the following two years, and then cease paying dividends altogether. How much is one share of this stock worth to you today if you require a 17 pe..
|
|
Find the highest salary of any instructor
: Find all instructors earning the highest salary (there may be more than one with the same salary).
|
|
Calculate project payback and discounted payback period
: The company can purchase new planning software for $3,600. The software (asset) has a two-year life, will produce a savings of $600 in the first year and $4,200 in the second year. The discount rate is 15%. Calculate the project's payback and discoun..
|
|
What ways does voltaire critique religion in candide
: If Aldous Huxley were alive today, what do you think he would have to say about his novel's relevancy to the modern world? Do you think he would say that we have moved closer to his vision or further away? Why or why not?
|
|
Care physician operates a sound business practice
: Your primary care physician operates a sound business practice that, at times, seems to suffer from several forms of waste. In your role as a dedicated patient engaged in the study of operations management, you are in a unique position to offer an..
|
|
Compute the discounted payback statistic for project
: Compute the discounted payback statistic for Project C if the appropriate cost of capital is 9 percent and the maximum allowable discounted payback period is three years.
|