FROM Employee
GROUP BY department;
CREATE VIEW DepartmentView AS
SELECT l.id, l.name, l.manager_name, r.total_salary
FROM __join_1 l
LEFT JOIN __aggregate_1 r ON l.id=r.department;
"""
import gevent
from engine import Table
#from engine.aggregate import Sum
Department = Table('Department', {
'id': int,
'name': str,
'manager': int,
})
Employee = Table('Employee', {
'id': int,
'name': str,
'department': int,
'salary': int,
})
# __join_1 = LeftJoin('__join_1', Department, 'manager', Employee, 'id', {
# 'id': 'id',
# 'name': 'name'}, {
# 'manager_name': 'name',
# })
