::fixture-ready:: $ sqlite3 app.db ".schema users" CREATE TABLE users ( id INTEGER PRIMARY KEY, email TEXT NOT NULL, created_at TEXT NOT NULL ); CREATE UNIQUE INDEX idx_users_email ON users(email); ::exit-code::0 $ sqlite3 app.db "SELECT email, count(*) FROM users GROUP BY email HAVING count(*) > 1;" alex@example.com|2 ::exit-code::0