How do I shot web?

found_it.sql

-- kick them to the curb unless they look like mick jagger
delete from measurements as m where m.id 
in
(
  -- This finds all of our duplicate measurements
  select id from measurements 
    inner join (
      select min(id) minid, keg_id, volume from measurements
      group by keg_id, volume
      having count(1) > 1
    ) as mi
  on (
    measurements.keg_id = mi.keg_id and
    measurements.volume = mi.volume and
    measurements.id <> mi.minid
  )
 );

query.sql

select distinct keg_id, volume from measurements;


-- I know this is wrong, but I don't know how to express it correctly :/
select id 
from measurements 
where 
  keg_id (select distinct keg_id, volume from measurements) 
  and 
  volume in (select distinct keg_id, volume from measurements);