medium10 pts · first answer countswindow-functionssqlgaps-and-islands

Counting ticket status changes

A ticket history table has one row per update, often repeating the same status. How do you count real status changes per ticket?

A.Count the distinct statuses each ticket has ever hadB.Count all history rows for each ticket and subtract 1C.Count rows where status differs from LAG(status) in time orderD.Count rows where status differs from MAX(status) for the ticket

Discussion 0

Join free to post in the discussion.

Counting ticket status changes

Discussion 0

Related questions