Problem Statement

A manufacturing company wants to identify machines that may require urgent maintenance. The company records machine details, machine-type operating limits, sensor readings, maintenance logs and fault events. Your task is to analyse the available data and print machines whose maintenance risk level is HIGH or MEDIUM . Data Structures Machines Table : machineId (unique identifier), machineName , machineType (such as PRESS, CUTTER, WELDER or PACKER). Machine Type Profiles Table : machineType , maxTemperature , maxVibration . Every machineType present in the Machines table has exactly one matching record here. Sensor Readings Table : readingId , machineId , readingDay , temperature , vibration . Maintenance Logs Table : maintenanceId , machineId , maintenanceDay , maintenanceType (PREVENTIVE or CORRECTIVE). Fault Events Table : eventId , machineId , eventDay , severity (LOW, MEDIUM or HIGH). Valid Record Rules A sensor reading is valid only when all of the following hold: Its machineId exi