SQL for duration of inspection required

Summary

Measure key metric

Content

SQL Guru's need some help figuring out what tables to get:

For receiving, we want to measure the duration of a receiving task to capture the receiving (CREATE) and the inspect (TASK) to capture the two dates and perform a duration calculation.

Key information needed in SQL: PO #, Receipt # (Create date), Line #, Item # Outcome of the inspection NOT INSPECTED, ACCEPTED, REJECTED including the date of the transaction showing the inspection being completed

Thanks!

Version

19d