1) Write a SELECT statement that returns the LastName and FirstName columns from the Students table, along with a count of the number of courses each student is taking from the StudentCourses table. Return one row for each student who is taking more than one class. To do that, use a subquery with the IN class that groups the student course by StudentID. Group and sort the result set by the LastName and then by the FirstName. 2) Write a SELECT statement that returns the LastName, FirstName, and AnnualSalary columns of each instructor that has a unique annual salary. In other words, don't include instructors that have the same annual salary as another instructor. Sort the results by LastName and then by FirstName.

1) Write a SELECT statement that returns the LastName and FirstName columns from the Students table, along with a count of the number of courses each student is taking from the StudentCourses table. Return one row for each student who is taking more than one class. To do that, use a subquery with the IN class that groups the student course by StudentID. Group and sort the result set by the LastName and then by the FirstName. 2) Write a SELECT statement that returns the LastName, FirstName, and AnnualSalary columns of each instructor that has a unique annual salary. In other words, don't include instructors that have the same annual salary as another instructor. Sort the results by LastName and then by FirstName.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write a function and a call program in PL/SQL to sum the even integers between 1 and any number that is passed as parameter to the function. Use the editor to format your answer
It's best to utilize an Oracle function to determine how many days have passed since your birthday.
Can you write an SQL program that includes tables that classify different levels of college students based on their GPA?
Are variables, decision structures, and loops used in other programming languages? How are the PL/SQL data types similar or different from variable types used in other languages?
Give specific examples of how calls and returns show what they mean in general.
Is this statement true or false: Oracle SQL allows full expression-based use of both provided (built-in) and user-definable functions.
This is for SQL Give me a list of all of our vendors (by their name) and, if they have an invoice, give me the total number of invoices we have from them and the invoice date of their first invoice. The invoice date results should be provided in a way that shows the date only in the following format: mm/dd/yyyy (e.g. 10/04/2021)
Could you please answer all the quastion please ASAP?
Need help writing SQL statements for these, I'm getting some errors for my returns.
Hello! I was given those tables(no data) and I am supossed to write sql code for the following. But I looks like I have a syntax error or there is something I have wrote wrong. (see images) (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (3) Create a trigger “change_price” on table “Inventory”. The trigger is fired before a change is made to the “Inventory” table. Before the price of an item is changed, the “itemid”, the item’s old price, the action, and the time of change are inserted into the table “Inventory_history”. The action is set to “price change”. Test your trigger by updating a row in Inventory…