[Solved]Using Sql Plus Omega Access Tables Created Project 2 Complete Following Sql Transactions L Q37299436

Using SQL*Plus on OMEGA, access the tables you created inProject 2 and complete the following SQL transactions. Log yourstatements and results by spooling your file (with echo on).Directions for creating and running SQL files are available in theAssignments and Exams page in Blackboard (in the Project 2 group offiles). All column headings must show in theirentirety. Be sure to include a cover sheet with your fullname, section, and date submitted.

27. 4 points

List the customer ID, first name, lastname, and total (sum of all fee amounts) of all Rentals forCustomer 23. Combine the first and last name into a single columnand show the total formatted as currency. Use the following columnheadings: Customer_ID, Customer_Name, Fee_Total.

28. 4 points

List the Rental ID, Rental date,customer ID, customer first name, customer last name, and customerphone number for all Rentals on or before 9/4/17. Sort by Rentaldate then by customer ID, both in ascending order. Show the Rentaldate formatted as ‘mm/dd/yyyy’ and show the phone number formattedas ‘(###) ###-####’.

29. 4 points

List the employee ID, first name, lastname, and count of Rentals for the employee(s) who have processedmore than one rental. Sort by count in descending order, then byemployee ID in ascending order. Use the following column headings:EmployeeID, FirstName, LastName, RentalCount. Hint: use a GROUP BYclause and a HAVING clause.

30. 3 points

List the customer ID, first name, andlast name of all customers whose first or last names start with theletter ‘J.’ Sort by last name and use the following columnheadings: Customer_ID, First_Name, Last_Name.

31. 4 points

List the customer ID, first name, andlast name for any customers who do not have any rentals. Use thefollowing column headings: CustID, FirstName, LastName. Hint: use aNested Select.

Expert Answer

---

Answer to Using SQL*Plus on OMEGA, access the tables you created in Project 2 and complete the following SQL transactions. Log you… . . .