Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SPOOL your output to c:cs422aproject2spool.txt Format COLUMN Headings and Formats for ROOMNUM, REGDATE, LASTNAME, ADULTCNT, CHILDCNT, and ROOMRATE BREAK on ROOMNUM and COMPUTE a total
SPOOL your output to c:\cs422a\project2spool.txt
Format COLUMN Headings and Formats for ROOMNUM, REGDATE, LASTNAME, ADULTCNT, CHILDCNT, and ROOMRATE
BREAK on ROOMNUM and COMPUTE a total of ROOMRATE for each ROOMNUM
SELECT the fields indicated above from DDI.LEDGER_VIEW for registrations between '01-JUN-15' and '07-JUN-15' (don't forget to order by ROOMNUM and REGDATE)
How would one run the command in SQL for this?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started