Find Longest Calls
SQL walkthrough with invented sample tables. Join each call to its contact, rank calls inside each type with RANK, keep ranks one to three, and show the first name with the duration as HH:MM:SS.
SQL walkthrough with invented sample tables. Join each call to its contact, rank calls inside each type with RANK, keep ranks one to three, and show the first name with the duration as HH:MM:SS.