1, what is the Average number of days it takes for a client to receive a visit (tbl_ClientVisits.clientVisit_id), from the time they were admitted for service as part of a treatment episode...

1, what is the Average number of days it takes for a client to receive a visit (tbl_ClientVisits.clientVisit_id), from the time they were admitted for service as part of a treatment episode (tbl.ClientEpisodes>auto_Admission_date)

consider the tables join is done

column needed -  ClientVisit_id

- Episode_id.

- auto_admission_date

- auto_discharge date

tbl_clientVisit represent all the visits the company client make to the business. each visit is associated with one, and only one clientEpisode, however, each episode may consists

of multiple visits.