So essentially I need to create a table that only shows chemicals that have a concentration 100 times the action level.
I'm pulling from chemical, action_level and result_numeric. I only want to see chemicals in which the result_numeric is 100x the action_level. How can I write this in sql? Is it possible?