Question
An eCommerce company has the following tables table: T1 (order id.amount.quantity date used ID) Table: T2 (user ID name state.city) Please write SQL queries for
An eCommerce company has the following tables table: T1 (order id.amount.quantity date used ID) Table: T2 (user ID name state.city) Please write SQL queries for the below points
1. MOM (month over month) growth of order from the state of Gujarat
2. which month of 2019 attributes the Highest % change in the total amount
3. Write query of Point 1 with a different logic and compare the performance
Note: You are allowed to make any assumption
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
SQL Server Query Performance Tuning
Authors: Sajal Dam, Grant Fritchey
4th Edition
1430267429, 9781430267423
