select max(study_custom1) as 'Outside Institution', COUNT(study_custom1) as 'Number of Studies' from pacsdb.study where accession_no like '%OUT%' and study_custom1 is not null and created_time >= DATE_FORMAT( CURRENT_DATE - INTERVAL 1 MONTH, '%Y/%m/01' ) AND created_time < DATE_FORMAT( CURRENT_DATE, '%Y/%m/01' ) group by study_custom1 order by 'Number of Studies' DESC
site3 5 site2 8 site8 2 site4 1 site1 12
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.