1. a)Write python code using pandas that will solicit user input in terms of a movie id (let the input movie id be X), and will output all movies from the database which have at least one genre common with X and have at least one rating identical to that of one of Xs ratings. For example, if X has genres [Crime|Thriller] and has fetched ratings [3.0, 4.0, 4.0], all Crime or Thriller movie that have fetched at least one rating of 3.0 or 4.0 would be output

1.b) Your solution for 1.a) is observed to produce a large number of movies in response to a user input. Think of a way to use the information from tags.csv to produce a list of tag-based similar subset of the results in 1.a) to highlight to the user.

Implement the question 1.a and 1.b using SQL statements called from pandas.