I need to calculate the average time difference between incidents per person.
Can it be done with sql ?
For example, My table looks like this:
The result should be like this:
Name, Average time between incidents(in days)