---------------------------------------------------------------------------
select title as project, lastname as employee, noofhoursperweek/40*salary as cost
from employee e
join empproj ep on ep.eid=e.eid
join project p on p.pid=ep.pid
order by project, employee;points = np.array([[1, 1], [2, 2], [3, 1], [1000, 1000]])
p = np.array([[800, 300]])
d = points - p
sd = np.square(d)
dists = sd.sum(axis=1)
dist = np.sqrt(dists)
dist.argmin()
---------------------------------------------------------------------------
...