Write the scalar function and stored procedure for the given database: 

 

Movies Key PK/FK Name Title Year Genre Lead Ranking Watched int The List Key PK/ FK Type nvarchar FK int int nvarchar nvarchar Name Title Medium Watched Shows Key PK/FK Type nvarchar bit bit Name Title Pilot Year Genre Lead Ranking Last EP -X Type nvarchar date nvarchar nvarchar int int