Question

Project 2 is about printing a formatted list of room registrations from DDI.LEDGER_VIEW

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 run the command for this?

Answer 1

I think you need SQL query for selectinf ROOMNUM and ROOMREG, so here it goes

SELECT SUM(ROOMRATE*COUNT(ROOMNUM)) AS ROOMNUM, REGDATE FROM DDI.LEDGER_VIEW BETWEEN '01-JUN-15' AND '07-JUN-15' ORDERBY ROOMNUM, REGDATE;