/*var mysql = require('mysql');

var con = mysql.createConnection({
  host: "172.25.21.233",
  user: "root",
  password: "test",
  database :'hamid_makic'
});
var muski=0,zenski=0;
con.connect(function(err) {
  if (err){
  console.log("error connecting:"+ err.stack);
return}

con.query("SELECT gender, COUNT(*) as count FROM employees GROUP BY gender;", function (err, result, fields) {
    if (err) throw err;
   console.log(result);
  con.end();
   // console.log(result.length);
  });

console.log('connected as id '+ con.threadId);
});*/

/*var mysql = require('mysql');

var con = mysql.createConnection({
  host: "172.25.21.233",
  user: "root",
  password: "test",
  database :'hamid_makic'
});
var muski=0,zenski=0;
con.connect(function(err) {
  if (err){
  console.log("error connecting:"+ err.stack);
return}

con.query("SELECT YEAR(birth_date) as godina, COUNT(*) as count FROM employees GROUP BY YEAR(birth_date);", function (err, result, fields) {
    if (err) throw err;
     result.forEach(function(result) {
    console.log('Uposlenika rodjenih '+ result.godina +' ima uposlenika ' + result.count + '.');
  });
  con.end();
  });

});*/

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "172.25.21.233",
  user: "root",
  password: "test",
  database :'hamid_makic'
});
var muski=0,zenski=0;
con.connect(function(err) {
  if (err){
  console.log("error connecting:"+ err.stack);
return}

con.query("SELECT last_name, first_name, gender, dept_no FROM `employees` INNER JOIN dept_emp ON dept_emp.emp_no = employees.emp_no WHERE dept_no like 'd002'" , function (err, result, fields) {
    if (err) throw err;
     console.log(result.length);

  con.end();
  });

});

SELECT last_name, first_name, dept_name FROM `employees`
INNER JOIN dept_manager ON dept_manager.emp_no = employees.emp_no
INNER JOIN dept_emp ON dept_emp.dept_no = dept_manager.dept_no
WHERE YEAR(CURDATE())<YEAR(to_date)