This is the schema I made: I am having a problem of doing the following in SQL please help me do the following below. You need the above schema information in order to do the following queries.

• need a query for table watchlist that can satisfy these options. must join across 3 tables (watchlist, media, users). would be a plus if it had a sub-query

need a query that can sort the media table by these options. Do the other options too. join with the platform table across the platform-media.

need the queries for these two

• need a query that can display those. so need an aggregation.