Complete and print the following SQL transactions. Log your statements and results by spooling your file (with echo on from Oracle if available).
List the ResNum, RoomNum, RoomTypeDesc, RateTypeDesc, and RateAmt for the room with the highest rate amount in reservation 1005. Show the rate amount formatted as currency and use the following column headings: ResNum, RmNum, RoomType, RateType, Rate.
SELECT R1.ResID as ResNum, R1.RoomNumber as RmNum, R2.RoomTypeDesc as RoomType,
R3.RateTypeDesc as RateType, ('$'+R1.RateAmt) as Rate
FROM ResDetail R1, RoomType R2, RateType R3, Room R4
WHERE R1.RateType = R3.RateType AND R1.RoomType = R4.RoomType AND
R4.RoomType = R2.RoomType
AND R1.RateAmt <= 1005
Complete and print the following SQL transactions. Log your statements and results by spooling your file...
Complete and print your statements and results by spooling your
file (with echo on from Oracle if available).
23] List the unique room number, room type description, rate
type description, and rate amount for all rooms that have been
reserved with a rate amount greater than $115 (do not include
duplicate rows). Sort by rate amount in descending order. Use the
following column headings: RmNum, RmType, RateType, RateAmt.
ResDetail Customer CustlD CustFName CustLName CustPhone CustType LoyaltylD Reservation ResID CheckinDate CheckOutDate...
Using SQL*Plus on OMEGA, access the tables you created in Project 2 and complete the following SQL transactions. Log your statements and results by spooling your file (with echo on). Directions for creating and running SQL files are available in the Assignments and Exams page in Blackboard (in the Project 2 group of files). All column headings must show in their entirety. Be sure to include a cover sheet with your full name, section, and date submitted. 19. 4 points...
I need help with certain questions. Please.
18. 4 points
For each Rental, list the Rental ID,
Rental date, customer ID, customer first name, customer last name,
and count of disks rented; sort by Rental ID. Show the Rental date
formatted as ‘mm-dd-yyyy.’ Hint: use a GROUP BY clause.
19. 4 points
List the disk ID, title name, rating,
format description, and fee amount for all copies rented in Rental
3; sort by disk ID. Show the fee amount formatted...