{
    "queries": [
        {
            "query": "SELECT \"WEBSITE\", SUM(\"PAGE VIEWS\") AS total_views FROM Website_Analytics GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Total page views for each website, highest first."
        },
        {
            "query": "SELECT \"YEAR\", SUM(\"PAGE VIEWS\") AS total_views, SUM(\"UNIQUE VIEWS\") AS total_unique FROM Website_Analytics WHERE \"PAGE VIEWS\" IS NOT NULL GROUP BY 1 ORDER BY 1",
            "description": "Yearly trend of total and unique page views."
        },
        {
            "query": "SELECT \"PAGE PATH\", SUM(\"PAGE VIEWS\") AS total_views FROM Website_Analytics WHERE \"WEBSITE\" = 'www.brla.gov' GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Most viewed pages on www.brla.gov."
        },
        {
            "query": "SELECT \"WEBSITE\", AVG(\"AVERAGE TIME ON PAGE (SECONDS)\") AS avg_seconds FROM Website_Analytics WHERE \"AVERAGE TIME ON PAGE (SECONDS)\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average time visitors spend on a page, by website."
        },
        {
            "query": "SELECT \"WEBSITE\", AVG(\"BOUNCE RATE (%)\") AS avg_bounce, AVG(\"EXIT RATE (%)\") AS avg_exit FROM Website_Analytics WHERE \"BOUNCE RATE (%)\" IS NOT NULL AND \"EXIT RATE (%)\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
            "description": "Average bounce and exit rates for each website."
        },
        {
            "query": "SELECT \"PAGE PATH\", \"YEAR\", \"PAGE VIEWS\", \"UNIQUE VIEWS\", \"ENTRANCES\" FROM Website_Analytics WHERE \"WEBSITE\" = 'data.brla.gov' AND \"PAGE VIEWS\" IS NOT NULL ORDER BY \"PAGE VIEWS\" DESC LIMIT 10",
            "description": "Top page-year records on data.brla.gov by page views."
        },
        {
            "query": "SELECT \"PAGE PATH\", SUM(\"ENTRANCES\") AS total_entrances FROM Website_Analytics WHERE \"ENTRANCES\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
            "description": "Pages where visitors most often enter the sites."
        },
        {
            "query": "SELECT MIN(\"YEAR\") AS first_year, MAX(\"YEAR\") AS last_year, COUNT(DISTINCT \"WEBSITE\") AS websites, COUNT(*) AS rows_total FROM Website_Analytics",
            "description": "Overview of the years, websites, and rows covered."
        }
    ]
}