Oracle db | Computer Science homework help

Oracle DB  

•Report 5 – A list of each channel (both channel name and channel number) and a count of the number of customers who picked that channel as a favorite channel.
•Report 6 – A summary of sales for any given day, categorized by package type (i.e., the total sales written on the specified day for each package subscribed to by customers, not bills paid). This report should give details about each package type, the package price, the number of packages sold, and then the total sales amount for that package. This is going to be a date driven report.