You are given an example database schema for Apify’s data warehouse with several core tables related to users, actors, actor_runs and user_pricing. After discussions with business teams, you also have a list of requirements for new reports which are to be created. Your task is to design a new derived table or tables that will make creating those reports easier and will make it faster for later analysis as well. Submit an SQL script that will create that table and describe any assumptions and reasoning you made.
