noted the sql command to build the report table