Northwind SQL
the database, directly
connecting…
SELECT c."Country", ROUND(SUM(od."UnitPrice" * od."Quantity")::numeric, 2) AS revenue FROM orders o JOIN order_details od ON o."OrderID" = od."OrderID" JOIN customers c ON o."CustomerID" = c."CustomerID" GROUP BY c."Country" ORDER BY revenue DESC LIMIT 10;
Run
Browse orders
Products by price
Try to write
Run a query.