Advertisement
Guest User

Untitled

a guest
Oct 1st, 2014
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. SELECT
  2. Employees.name as EmpName,
  3. (select count(LateDays.LateDate)*200 from Employees inner join LateDays on Employees.EmpId = LateDays.EmployeeEmpId) as TotalFine,
  4. count(LateDays.LateDate)*200 as PaidFine,
  5. (select COUNT(LateDays.Informed)from Employees inner join LateDays on Employees.EmpId = LateDays.EmployeeEmpId where LateDays.Informed='true') as InformedDays
  6. FROM
  7. Employees inner join LateDays
  8. on Employees.EmpId = LateDays.EmployeeEmpId
  9. WHERE
  10. LateDays.FinePaid = 1
  11. GROUP BY
  12. name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement