git clone [email protected]:thangchung/mcp-labs.git
cd mcp-labs/vscode-mcp-servers
dotnet build
dotnet run --project AppHost1/AppHost1.csproj

SELECT o.order_id, o.customer_id, c.company_name, o.order_date, o.shipped_date,
       ROUND(SUM(od.unit_price * od.quantity * (1 - od.discount))::numeric, 2) AS total_order_value,
       COUNT(od.product_id) AS total_items,
       o.freight, o.ship_country
FROM orders o
INNER JOIN order_details od ON o.order_id = od.order_id
LEFT JOIN customers c ON o.customer_id = c.customer_id
GROUP BY o.order_id, o.customer_id, c.company_name, o.order_date, o.shipped_date,
         o.freight, o.ship_country
ORDER BY total_order_value DESC
LIMIT 10;