Guest User

Untitled

a guest
Feb 18th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.12 KB | None | 0 0
  1. CREATE VIEW vw_EmployeeAvgSalary
  2. AS
  3. (SELECT jobCode, AVG(salary) AS AvgSalary
  4. FROM Employee
  5. GROUP BY jobCode)
Add Comment
Please, Sign In to add comment