Company: IBM
Difficulty: medium
Problem Description As part of a data center's network security audit, write a SQL query to return a list of Internet gateways that meet the following criteria: They have strictly more than one firewall assigned to them. Their assigned firewalls have cumulatively reached or exceeded the maximum allowed threshold of 100 traffic rules . Schema firewalls Table Column Name Data Type Description firewall_id INT Primary key. The unique identifier for the firewall. gateway_id INT The identifier of the Internet gateway the firewall is assigned to. rules_count INT The number of traffic rules currently configured on the firewall. Required Output The result set should contain the following columns, ordered by gateway_id in ascending order: gateway_id : The ID of the Internet gateway. total_rules_count : The sum of the rules_count from all firewalls assigned to that specific gateway. Constraints or Notes A firewall belongs to exactly one Internet gateway. Only Internet gateways with strictly >