RedmondLonghorn
Footballguy
The work product from my last several hours of work:
Jobs are neat.(FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="15" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="23" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="31" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="52" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="53" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="55" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="56" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="57" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="58" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="72" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="78" OR FREF_ENTITY_SIC_CODE(MAJGRP,VAL,RANK1)="79" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="251" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="273" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="277" OR OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="302" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="301" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="363" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="365" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="375" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="393" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="394" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="448" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="472" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="483" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="484" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="501" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="592" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="594" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="599" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="701" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="753" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="829" OR FREF_ENTITY_SIC_CODE(INDGRP,VAL,RANK1)="835" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="2273" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="2711" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="2721" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3711" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3714" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3792" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3799" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3911" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3914" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3951" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3952" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="3961" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5091" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5112" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5136" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5137" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5139" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5461" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="5961" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="7342" OR FREF_ENTITY_SIC_CODE(INDUSTRY,VAL,RANK1)="7312")=1