in SQL query,how to use the query to get the following result in the movie purchasing and selling system?1.which actor plays the most popular movie?2,which type of movie sell most food and beverage?3.which time period,the movie and food have the highest revenue?4.which cinema is most close to the customer location?there are part of ER relationship,but can u show me your thinking about how to write the relevant query to answer the question?thank u!

boom Pk boom Pk