I have license data of an inspector in which Inspector_ID, Activation_date, Expiry_Date and other fields. Once the license is expired, they may issue new license for the same inspector. So the Inspector_IDs are not unique. How do i get to know the number of inspectors whose license is expired for selected period.
Eg:
ID ActDate ExpDate
1 1 Jan 18 3 Mar 18
2 2 Jan 18 10 Mar 18
3 4 Apr 18 10 Dec 18
1 4 Mar 18 12 Dec 18
if the selected period is Jun 2018, Result should be 1 (ID = 2)
