var mysql=require('mysql');
var con = mysql.createConnection({
  host: "172.25.21.233",
  user: "root",
  password: "test",
  database:"david_dautbegovic"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  con.query('select e.first_name from employees as e inner join dept_emp as de on e.emp_no=de.emp_no group by e.first_name having count(de.emp_no)>=2',function(err,result){
    if(err) throw err
    //console.log(result);
})
var zaposlenici;
var Smanjeni=[];
var brojac=0;
con.query('select s.emp_no,s.salary from employees as e inner join salaries as s on s.emp_no=e.emp_no order by s.emp_no,s.from_date',function(err,result){
    if(err) throw err;
    zaposlenici=result;
   // console.log(zaposlenici);
    for(var i=0;i<zaposlenici.length;i++){
        if(zaposlenici[i+1]!=undefined){
           // console.log('proso undefined',zaposlenici[i],' - ',zaposlenici[i+1]);
            if(zaposlenici[i].emp_no===zaposlenici[i+1].emp_no)
            {
                //console.log('nadjen isti zaposlenik');
                if(zaposlenici[i].salary>zaposlenici[i+1].salary)
                {
                    brojac++;
                    //console.log('ispunio uslov');
                    Smanjeni.push(zaposlenici[i].emp_no);
                }
            }
        }

    }
console.log(brojac);

})
});