Write a SQL query using joins and aggregate functions to find data anomalies in Samsung Semiconductor manufacturing logs.