Subversion Repositories computer_asset_manager_v1

select 
   year.device_id,
   week.device_id,
   device.name
from 
   (select distinct(device_id) from sysinfo_report where report_date > 20150101 ) year
   left join
   (select distinct(device_id) from sysinfo_report where report_date > 20160607 ) week
   using (device_id)
   join device using (device_id)
where week.device_id is null;