PL-SQL Our Tables: Devices Table Specs Table Retrieve the name of each Machine and the names of the sensors related to this machine: Retrieve all device names and all the specs names and values defined to each device: Retrieve the sensor name with only one specification and retrieve the machine name of this sensor: Retrieve the intersection between the two tables based on the ID column from Specs table and the SpecID from Devices table: Retrieve all Specifications names and the number of sensors related to each specification:
