Examples of SQL queries for reports

Example : The report "URL Detail"

Query <b>URL Detail</b>
SELECT
        Hit.hitdelay as "delay",
        Hit.hitdate as "date_hit",
        Hit.cputime - Hit.cpuusertime as "cpu_time",
        Hit.cpuusertime as "cpu_user_time",
        HitResult.hitresultvalue as "result",
        Hit.waitdelay as "wait_delay",
        Hit.waitcount as "wait_count",
        Hit.blockingdelay as "blocking_delay",
        Hit.blockingcount as "blocking_count",
        HitURL.responsecode as "response_code"
FROM
        App,
        Webapp,
        Feature,
        URL,
        Hit,
        HitURL,
        DelayType,
        HitResult,
        Org,
        Env,
        Host,
        EnvHostAssoc
WHERE
        App.appId = Webapp.appId AND
        App.appId = Feature.appId AND
        Webapp.webappId = URL.webappId AND
        Feature.featureId = URL.featureId AND
        Feature.featureId = Hit.featureId AND
        Hit.hitId = HitURL.hitId AND
        Org.orgId = env.orgId AND
        Env.envId = EnvHostAssoc.envId AND
        Host.hostId = EnvHostAssoc.hostId AND
        Hit.hostId = Host.hostId AND
        Hit.delayType = DelayType.delayTypeId AND
        Hit.hitResult = HitResult.hitResultId AND
        DelayType.delayTypeCode = 'Server' AND
        Hit.parentId is null AND
        App.appId = ? AND
        Env.envId = ? AND
        Hit.hitDate > ? AND
        Hit.hitDate < ? AND
        Feature.featureName = ?
ORDER BY
        Hit.hitDate

Example : The report "Average Response Time"

Query <b>Average Response Time</b>
SELECT
        Hit.hitDelay as "hitdelay",
        Hit.hitDate as "hitdate"
FROM
        App,
        Webapp,
        Feature,
        URL,
        Hit,
        HitURL,
        DelayType,
        HitResult,
        Org,
        Env,
        Host,
        EnvHostAssoc
WHERE
        App.appId = Webapp.appId AND
        App.appId = Feature.appId AND
        Webapp.webappId = URL.webappId AND
        Feature.featureId = URL.featureId AND
        Feature.featureId = Hit.featureId AND
        Hit.hitId = HitURL.hitId AND
        Org.orgId = env.orgId AND
        Env.envId = EnvHostAssoc.envId AND
        Host.hostId = EnvHostAssoc.hostId AND
        Hit.hostId = Host.hostId AND
        Hit.delayType = DelayType.delayTypeId AND
        Hit.hitResult = HitResult.hitResultId AND
        DelayType.delayTypeCode = 'Server' AND
        Hit.parentId is null AND
        App.appId = ? AND
        Env.envId = ? AND
        Hit.hitDate > ? AND
        Hit.hitDate < ?