Question $2$

As part of data center software development, create a query that returns a list of all Internet gateways that meet the following criteria:

They have more than one firewall assigned.

Their assigned firewalls have cumulatively reached the maximum allowed number of traffic rules.

The result should have the following columns: gateway id $/$ total$\_$rules$\_$count.

gateway id $-$ Internet gateway ID

total$\_$rules count $-$ the sum of all firewall rules for a specific Internet gateway

Note:

Each internet gateway can be assigned one or more firewalls, while a particular firewall can belong to only one specific Internet gateway.

Only Internet gateways that have more than one firewall assigned should be included in the result.

Only Internet gateways whose assigned firewalls, in total, have reached the maximum allowed number of traffic rules should be included in the result.

The maximum number of traffic rules allowed is $100.$

Schema

Sample Data Tables