Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- group_name,
- Definition_Range,
- COUNT([group_name]) AS Number_of_Clients
- FROM [Computer Status]
- WHERE
- Definition_Range = ' 0-10 Days'
- GROUP BY
- group_name,
- (
- SELECT
- COUNT([group_name]) AS Total_Clients
- FROM [Computer Status]
- GROUP BY group_name
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement