SELECT 
    EXTRACT(HOUR FROM order_timestamp) AS order_hour,
    COUNT(*) AS total_orders
FROM orders
GROUP BY order_hour
ORDER BY total_orders DESC
LIMIT 1;

📌 Question 40: Rank Salespersons by Quarterly Revenue

Table: sales salesperson_id, amount, sale_date

WITH quarterly_sales AS (
    SELECT 
        salesperson_id,
        DATE_TRUNC('quarter', sale_date) AS quarter,
        SUM(amount) AS revenue
    FROM sales
    GROUP BY 1,2
)
SELECT *,
    DENSE_RANK() OVER (
        PARTITION BY quarter 
        ORDER BY revenue DESC
    ) AS sales_rank
FROM quarterly_sales;

Double Tap ❤️ For More