Now that you have completed the profitability analysis for product categories and subcategories, it is time to solve the second problem statement. Let’s watch the upcoming video and learn more about it.
As you learnt in this video, there is a major difference between this problem statement and the one you solved in the previous segment. You already have the expected output table that contains the required columns. Sometimes, interviewers test whether you can write the exact query that is required for extracting the expected output.
The problem statement, the expected output format and the required tables can be summarised as follows:
Problem statement: Extract the details of the top ten customers in the expected output format.
Expected output format: The expected output format is given in the table below.
Tables: The tables that are required for solving this problem are as follows:
- ‘cust_dimen’
- ‘market_fact_full’