Database

SELECT
    DateRented,
    COUNT(1) As TotalRentals,
    SUM(DVD) As DVDRentals
 
FROM
(
    SELECT
        CAST(
            CAST(Year(DateRented) As varchar(4))
            + '/' + CAST(Month(DateRented) As varchar(2))
            + '/' + CAST(Day(DateRented) As varchar(2))
        As datetime) As DateRented,
        
        CASE
            WHEN RentalType = 'DVD' THEN 1
            ELSE 0
        END As DVD
        
    FROM
        Rentals
        
) As R
 
GROUP BY
    DateRented
ORDER BY
    DateRented

select trunc(DateRented) DateRented,<br />
  count(*) TotalRentals,<br />
  sum(decode(RentalType, 'VHS', 1, 0)) VHSRentals,<br />
  sum(decode(RentalType, 'DVD', 1, 0)) DVDRentals,<br />
from Rentals<br />
group by trunc(DateRented)

SELECT DateValue(rentaldate) AS RentalDay,<br />
   COUNT(*) AS TotalRentals,<br />
   sum(IIf(rentaltype='VHS',1,0)) AS VhsRentals,<br />
   sum(IIf(rentaltype='DVD',1,0)) AS DvdRentals<br />
FROM Rentals<br />
GROUP BY DateValue(rentaldate);