Trending @Infosys; Need Unix shell script

Hi any one can help me Objective: create a script in such away that SQL query needs to execute its output check need to check with activity date as sysdate-1 and update date is sysdaye if it's correct return validated ales no match