I'mlooking to combine certain data, but my SQL knowledge is lacking to do so...
I've got an employee table:
A table with subtypes:
And I've got time.
Everyday an employee will have a certain subtype. For example:
JAN 2017 week 1:
employee1 subtype 100
employee2 subtype 100
employee3 subtype 100
FEB 2017 week 2:
employee1 subtype 100 (day 1-3)
employee1 subtype 200 (day 4-5)
I need to calculate the percentage of employees that do not have subtype 200 over the selected time period (ideally over the span of 52 weeks).
How can I do this? Thanks a lot for helping!
Retrieving data ...