Amazon BIE 2nd Phone Interview SQL

image

Questions:

  1. 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)

  2. Among all US customers who rented a video on Feb-01, what % of them streamed a video between feb-02 and feb-08?

  3. 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'

Comments (10)