Nepotism: if a director hires an actor with the same last name but different first name, this is a potential case of nepotism. For each director, report the number of actors the director has hired on any movie he/she directs with the the same last name but different first name. Include directors who are not guilty of nepotism with a count of zero. For each director, return one tuple with the director's id along with first and last names of the director and the number of such (potentially related) actors. If an actor is hired for multiple moviews or roles, just count him/her once. In the SQL, order the output by director id, Iname (of director), frame (of director). actors first name has wamerad M movies year raak 112290 Fight Club 1995 209658 Moet the Parents 2000 210511 Moment 2000 roles actor men 313395 Cat. James T. Kirk 433259 407323 Sgt. The 9936 3421 Herself 79736 directors id First name last_name 24758 David Fincher 6695 Jay Roach 72723 William Shar movies directors director id movie id 24758 112290 209658 72723 31339 movies genres movie Hd 209658 Comedy 313398 Action 313398 Sci-Fi Nepotism: if a director hires an actor with the same last name but different first name, this is a potential case of nepotism. For each director, report the number of actors the director has hired on any movie he/she directs with the the same last name but different first name. Include directors who are not guilty of nepotism with a count of zero. For each director, return one tuple with the director's id along with first and last names of the director and the number of such (potentially related) actors. If an actor is hired for multiple moviews or roles, just count him/her once. In the SQL, order the output by director id, Iname (of director), frame (of director). actors first name has wamerad M movies year raak 112290 Fight Club 1995 209658 Moet the Parents 2000 210511 Moment 2000 roles actor men 313395 Cat. James T. Kirk 433259 407323 Sgt. The 9936 3421 Herself 79736 directors id First name last_name 24758 David Fincher 6695 Jay Roach 72723 William Shar movies directors director id movie id 24758 112290 209658 72723 31339 movies genres movie Hd 209658 Comedy 313398 Action 313398 Sci-Fi