delete from datavalueaudit where organisationunitid in(select organisationunitid from organisationunit); delete from datavalue where sourceid in(select ...

-- Each row of this table contains an email. The emails will not contain uppercase letters. -- Write an SQL query to delete all the duplicate emails, keeping only one unique email with the smallest id ...