Order Status :

This query groups the orders by their status column and counts the number of orders for each status. The results will show the different statuses and the corresponding count of orders for each status. 

Top 10 State :

This query retrieves the top ten states with the highest total order amounts from a table named data. It selects the ship-state column and the sum of amount for each state, groups the orders by the ship-state column, orders the results by the total amount in descending order, and limits the output to the top ten rows.

The result of this query will show the top ten states with the highest total order amounts, along with the total amount of orders for each state.

 Count of orders for each channel : 

This query retrieves the top three channels with the highest order count from a table named data. It selects the channel column and counts the number of times the order id appears for each channel, groups the orders by the channel column, orders the results by the count of orders in descending order, and limits the output to the top three rows.

The result of this query will show the top three channels through which orders were placed, along with the count of orders for each channel.

Top Category in Sales :

This query retrieves the top-selling category from a table named data. It calculates the total amount and count of orders for each category, groups the results by the category column, and orders the output in descending order of the total amount of sales and total count of orders. The result is a table with three columns - category, Total_Amount, and Total_Count. 

Sales by Gender :

This SQL query retrieves the total sales amount for each gender from a table named data. It selects the Gender column and calculates the sum of the Amount column for each gender using the SUM function. The results are then grouped by the Gender column, and the output is ordered in descending order of the total sales amount using the ORDER BY clause. 

Top Product Sales Amt by State :

This SQL query retrieves the count of sales of the top product category, which is 'set', in each state from a table named data. It selects the ship-state column and calculates the count of orders where the category column is equal to 'set' using the COUNT function. The results are then grouped by the ship-state column, and the output is ordered in descending order of the count of sales of the top product category. 

Total Order by Channel with state :

This SQL query retrieves the total number of orders for each state with different channels from a table named data. It selects the Channel and ship-State columns and calculates the count of order id column for each state and channel using the COUNT function. The results are then grouped by the Channel and ship-State columns, and the output is ordered in descending order of the total number of orders. 

Orders by Channel in Delhi :

This SQL query retrieves the total number of orders for each channel in New Delhi from a table named data. It selects the Channel and ship-State columns and calculates the count of order id column for New Delhi using the COUNT function. The results are then grouped by the Channel and ship-State columns where the ship-State is equal to 'New Delhi' using the HAVING clause, and the output is ordered in descending order of the total number of orders. 

Total Product Quantity by Channel:

This SQL query retrieves the total quantity of products sold in each state by channel from a table named data. It selects the Channel and ship-State columns and calculates the sum of the qty column for each channel and state using the SUM function. The results are then grouped by the Channel and ship-State columns and the output is ordered in descending order of the total quantity of products sold. 

Orders by State :

This SQL query retrieves the total number of orders for each state from a table named data. It selects the ship-state column and calculates the count of the order id column for each state using the COUNT function. The results are then grouped by the ship-state column. 

Date wise sales report :

This SQL query retrieves the total sales amount, total orders, and total quantity of products sold for each date from a table named data. It selects the date column and calculates the sum of the amount column for each date using the SUM function. It also calculates the count of the order id column and the sum of the qty column for each date. The results are then grouped by the date column. 

Popular product :

This SQL query retrieves the total quantity and total sales amount for each product category and gender combination from a table named data. It selects the category, gender, and calculates the sum of the qty and amount columns for each combination using the SUM function. The results are then grouped by the category and gender columns. 

Sales and quantity by order id :

The given SQL query retrieves the total quantity and total sales amount for each order ID from a table named data.

The first query select distinct('order id') from data returns a list of distinct order IDs from the data table.

The second query selects the distinct order IDs and calculates the sum of the qty and amount columns for each order ID using the SUM function. The results are grouped by the order_id column and sorted in descending order of the total_amount column.

Sales amount, quantity by age :

The given SQL query retrieves the total quantity and sales amount for each age group from a table named data.

The query selects the Age column from the data table and calculates the sum of the qty and amount columns for each age group using the SUM function. The results are grouped by the Age column and sorted in descending order of the Amount column.

Category and Size wise sales  :

This query is retrieving the category and size wise order count, quantity, and amount. It's grouping the data by category and size, and then calculating the count of order ids, the sum of the quantity, and the sum of the amount for each group. It's also ordering the results by size and amount in descending order. 

Price Table :

This will create a new table "Price" with columns for category, size, orders, quantity, and amount, and populate it with the data from the this query. 

Price by Category :

This query will retrieve the Category, Size, and the calculated Price (which is the total Amount divided by the total Quntity) for each product.