Round - 1
The first round is the coding round in which she asked 2 SQL Questions
table 1 - order
order id | order date | product id | selling price |
|---|---|---|---|
table 2 - product
product id | current price | created at | product category |
|---|---|---|---|
Q1- to fetch 2024 each month on month no of sales product sold average selling price and total revenue
Q2- query to fetch 3rd highest selling product of each product category