exports.getClimateMinMax = async function (dbConn) { console.log('getClimateMinMax') const sqlMin = `SELECT MIN(temperature_mean) AS temperature_mean, MIN(temperature_mean_min) AS temperature_mean_min, MIN(temperature_mean_max) AS temperature_mean_max, MIN(precipitation) AS precipitation, MIN(rain_days) AS rain_days, MIN(sun_hours) AS sun_hours FROM region_climate` const sqlMax = `SELECT MAX(temperature_mean) AS temperature_mean, MAX(temperature_mean_min) AS temperature_mean_min, MAX(temperature_mean_max) AS temperature_mean_max, MAX(precipitation) AS precipitation, MAX(rain_days) AS rain_days, MAX(sun_hours) AS sun_hours FROM region_climate` const [qResMin, qResMax] = await Promise.all([dbConn.query(sqlMin), dbConn.query(sqlMax)]) // console.log(qResMin) return { min: qResMin[0], max: qResMax[0] } }