🏠 Home
Benchmark
📊 Tutti i benchmark 🦖 Dinosauro v1 🦖 Dinosauro v2 ✅ App To-Do List 🎨 Pagine libere creative 🎯 FSACB - Ultimate Showcase 🌍 Benchmark traduzione
Modelli
🏆 Top 10 modelli 🆓 Modelli gratuiti 📋 Tutti i modelli ⚙️ Kilo Code
Risorse
💬 Libreria di prompt 📖 Glossario IA 🔗 Link utili
Advanced

Generate a Complex SQL Query

#sql #database #data-analysis

Write a SQL query to join tables and filter specific data points.

You are a SQL expert. Write a query for a PostgreSQL database. You have two tables: 'Orders' (columns: order_id, customer_id, order_date, total_amount) and 'Customers' (columns: customer_id, name, country). Write a query to list the top 5 countries by total revenue generated in the year 2023. Include the country name and the total revenue, ordered by revenue in descending order.