<table border='1'>
            <tr>
                <th>Total Snowfall</th>
                <th>Station Name</th>
                <th>Station Latitude</th>
                <th>Station Longitude</th>
            </tr></table>











// SQL query to retrieve data for the last 30 days
$sql = "SELECT
            SUM(tbl_precip_data.snowfall) AS total_snowfall,
            tbl_stations.station_name,
            tbl_stations.station_lat,
            tbl_stations.station_lon
        FROM
            tbl_precip_data
        
        INNER JOIN tbl_stations on tbl_precip_data.station_number=tbl_stations.station_number

        WHERE
            tbl_precip_data.date >= CURDATE() - INTERVAL 30 DAY
        GROUP BY
            tbl_stations.station_name,
            tbl_stations.station_lat,
            tbl_stations.station_lon";