Scribd Logo
Upload

Welcome to Scribd!

  • 1 views

    _Data Analyst SQL -Assignment

    Uploaded by

    laharigowd19
    Sql

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    _Data Analyst SQL -Assignment

    Uploaded by

    laharigowd19
    1 views2 pages
    Sql

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Sql

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1 views2 pages

    _Data Analyst SQL -Assignment

    Uploaded by

    laharigowd19
    Sql

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    Data Analyst SQL Test

    Introduction
    Welcome to the SQL coding test. In this exercise, you will work with a dataset consisting of
    three related tables: Orders, Returns, and Users.

    ● Orders: This table contains detailed information about each sales transaction,
    including the unique order ID, customer details, product specifics, order date,
    quantity ordered, unit price, and total sales amount. It also captures the order priority
    and the region where the order was placed.
    ● Returns: This table records the status of order returns, linked by the order ID from
    the Orders table. It indicates whether an order has been returned.
    ● Users: This table lists regional managers and the regions they oversee, associating
    each region with a specific manager.

    Your task is to write SQL queries to extract and analyse data from these tables. This will test
    your ability to join tables, perform aggregations, and handle various data scenarios.

    Please ensure your queries are well-commented and formatted for readability. Good luck!

    Instructions
    ● Use standard SQL syntax.
    ● Format your queries for readability.
    ● Write the Query followed by a step by step explanation of your logic.

    Data
    The schema for the Dataset:
    Tasks
    Task 1: Which Manager has the highest Sales?
    Task 2: Which is the 2nd most sold Product? How much revenue did it generate?
    Task 3: Who are our Top 3 customers that return the most Products?
    Task 4: Give me a month-wise breakdown of the number of Products sold and the sales
    generated through it.
    Task 5: Are there any other interesting insights we can get from this data?

    Kindly submit your answers in the google form link provided:

    https://docs.google.com/forms/d/e/1FAIpQLScZD0tijskFz4ZTZ3Akip8e3SFAeJR
    w6OwRDLZwmFAyf1WAzA/viewform

    Thank you !!

    You might also like