VIP 👤
🏠 Hem
Benchmarkar
📊 Alla benchmarkar 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List-applikationer 🎨 Kreativa fria sidor 🎯 FSACB - Ultimata uppvisningen 🌍 Översättningsbenchmark
Modeller
🏆 Topp 10 modeller 🆓 Gratis modeller 📋 Alla modeller ⚙️ Kilo Code
Resurser
💬 Promptbibliotek 📖 AI-ordlista 🔗 Användbara länkar 🔌 AI-API:er och routrar
Intermediate

Generate SQL Query

#sql #database #data

Write a SQL query based on a specific data requirement description.

Write a SQL query for a PostgreSQL database. The goal is to retrieve the names and email addresses of users who registered in the last 30 days but have not yet verified their email. Assume the table name is 'users' with columns 'id', 'name', 'email', 'created_at', and 'is_verified'.