SUBJECT: postgreSQL

1. Create a stored procedure where you can input a movie title or actors name you like, and it will return the top five suggestions based on either movies the actor has starred in or films with similar genres.

2. Expand the movies database to track user comments and extract keywords (minus English stopwords). Cross-reference these keywords with actors last names, and try to find the most talked about actors.

I am a beginner at postgreSQL so please use simple code in order to solve these 2, not too complex.

THANK YOU SO MUCH IN ADVANCE