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

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.

19. 4 points

List the disk ID, title name, rating,format description, and fee amount for all copies rented in Rental3; sort by disk ID. Show the fee amount formatted as currency anduse the following column headings: DiskID, Title, Rating, Format,Fee.

20. 3 points

List the rating, rating description,and count of titles for each rating. Hint: use a GROUP BYclause.

21. 4 points

List the rental ID, disk ID, titlename, genre name, fee code, and fee amount for all titles that havea fee amount greater than the average fee for all Rentals (usingthe average of the fees for all RentalDetail rows, not the averageof the fees in the fee code table). Sort by title name. Hint: use anested SELECT.

22. 3 points

List the unique title ID, title name,genre name, and rating for all titles that have been rented with afee code of ‘B’ (do not include duplicate rows). Sort by titlename.

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… . . .