Advertisement
Guest User

Untitled

a guest
May 31st, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT
  2. group_name,
  3. Definition_Range,
  4. COUNT([group_name]) AS Number_of_Clients
  5. FROM [Computer Status]
  6. WHERE
  7. Definition_Range = ' 0-10 Days'
  8. GROUP BY
  9. group_name,
  10. (
  11. SELECT
  12. COUNT([group_name]) AS Total_Clients
  13. FROM [Computer Status]
  14. GROUP BY group_name
  15. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement