Question d’entretien chez Netflix

design star schema and some easy leetcode type problem. fairly easy stuff to code some sql and python. sql had some window functions and pythong with dictionaries . design and query this star schema for subscriptions