what will be the query to get min and max at once I am getting errors in this query
router.get('/min/:date', (req, res) => {
const date = req.params.date;
console.log(typeof date);
connection.query(
`select max(temperature) as highesttemperature; select min(temperature) as lowesttemperature from weather_data where dt=?`,
[date],
(err, results, field) => {
if (err) {
console.log(err);
} else {
res.status(200).send(results);
console.log(results);
}
}
);
});