🧪 Practical Interview Challenge
Suppose you have Orders with:
1001 North Electronics 80,000
1002 North Furniture 40,000
1003 South Electronics 70,000
1004 South Furniture 50,000
1005 North Electronics 60,000
Q1. Find total sales.
SELECT SUM(Sales) AS Total_Sales FROM Orders;
Q2. Find average sales.
SELECT AVG(Sales) AS Average_Sales FROM Orders;
Q3. Find sales by region.
SELECT Region, SUM(Sales) AS Total_Sales FROM Orders GROUP BY Region;
Q4. Count orders by region.
SELECT Region, COUNT(*) AS Order_Count FROM Orders GROUP BY Region;
Q5. Find average sales by category.
SELECT Category, AVG(Sales) AS Average_Sales FROM Orders GROUP BY Category;
Q6. Show only regions with sales greater than ₹100,000.
SELECT Region, SUM(Sales) AS Total_Sales FROM Orders GROUP BY Region HAVING SUM(Sales) > 100000;
Q7. Sort regions by highest sales.
SELECT Region, SUM(Sales) AS Total_Sales FROM Orders GROUP BY Region ORDER BY Total_Sales DESC;
🏆 Double Tap ❤️ For More