просто используйте общую таблицу
With CTE_Duplicates as
(select picture_id ,date , row_number() over(partition by picture_id,date order by picture_id ,date ) rownumber
from `pictures` )
delete from CTE_Duplicates where rownumber!=1
, она работает для me.please check