Workstations reflecting Multiple Tuners - SQL

    Select inv_machine.name machine_name, count(inv_tuner.machine_id) as 'Multiple Tuner ID Count' 

    from inv_tuner, inv_machine

    where inv_machine.id = inv_tuner.machine_id

    and inv_tuner.machine_id in (select distinct inv_tuner.machine_id from inv_tuner group by inv_tuner.machine_id having count(*) > 1  )
    group by inv_machine.name

    order by 2