Print a simple report using SQL

SPOOL your output to c:\CS4210\project2spool.txt

Use COLUMN to set up appropriate column headings and formats for DDI.LEDGER_VIEW

Field Heading Format REGID RegID 99999999 REGDATE Date DATE NAME Name A20 ROOMNUM Room 99999999 ROOMRATE Rate 999,999.00

Set appropriate values for PAGESIZE (255), LINESIZE (80) and TTITLE

Add BREAK and COMPUTE for subtotal and total of ROOMRATE Break on ROOMNUM for the subtotal and REPORT for total

Run a SQL command to print records from DDI.LEDGER_VIEW where REGDATE < '08-JUN-15' and sort by ROOMNUM and REGDATE

Close spool