const mysql = require('mysql2');
// create the connection to database
const connection = mysql.createConnection({
host: '2001:6b0:1:1300:250:56ff:fe01:25a', user: 'jacobmaadmin',
password: 'PieVie3aik',
database: 'jacobma'});

//2001:6b0:1:1300:250:56ff:fe01:25a
// password: 'PieVie3aik',
//mysql-vt2019.csc.kth.se
//connection.query('USE jacobma');

let maxPris = 'SELECT MAX(pris) as res from bostader';
let minPris = 'SELECT MIN(pris) as res from bostader';

let maxArea = 'SELECT MAX(area) as res from bostader';
let minArea = 'SELECT MIN(area) as res from bostader';

let list = [maxPris, minPris];


let valueList = new Array();
for (let t of list){
  connection.query(t,
  function(err, results, fields) {
    //console.log(results);
    valueList.push(results);
  });
}

console.log(valueList); // blir tom!!