
Questions:
Write a query to calculate how many customers in UK
a. streamed a video in the last month
b. rented a video in the last month
c. did both streaming and rented in the last month
(give all the three answers in one query)
Among all US customers who rented a video on Feb-01, what % of them streamed a video between feb-02 and feb-08?
Write a query to return, each device type, the top five customers that had the hightest minutes streamed during the last 7 days in 'JP'