Hi I am writing an IF statement to extract max and min of the water depth from the monitoring record table.The monitoring table have some other gas monitoring related data however I am interested in filtering it by WDEP (water related monitoring) type…