🏠 Accueil
Benchmarks
📊 Tous les Benchmarks 🦖 Dinosaure v1 🦖 Dinosaure v2 ✅ To-Do List Apps 🎨 Pages Libres 🎯 FSACB - Showcase 🌍 Traduction
Modèles
🏆 Top 10 Modèles 🆓 Modèles Gratuits 📋 Tous les Modèles ⚙️ Modes Kilo Code
Ressources
💬 Prompts IA 📖 Glossaire IA 🔗 Liens Utiles
Hard

Generate a SQL JOIN Query

#sql #database #technical

Write a SQL query to join two tables and filter results.

Write a SQL query for a database with two tables: 'Customers' (id, name, city) and 'Orders' (order_id, customer_id, amount, date). The query should list the names of all customers who live in 'New York' and have placed an order with an amount greater than $100 in the last 30 days.