🏠 Accueil
基準測試
📊 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 📖 人工智能詞彙表 🔗 Liens Utiles
Advanced

SQL Data Integrity Verification

#sql #database testing #data integrity

Write SQL queries to verify data integrity and referential constraints in a database.

Write a set of SQL queries to perform data integrity checks on a database with `Orders` and `Customers` tables. The queries should identify orphan records (orders with no customer), duplicate customer email addresses, and orders with a negative total amount. Explain the purpose of each query.