Code example 5-1SELECT VendorState, VendorCity, VendorName,…

Code example 5-1SELECT VendorState, VendorCity, VendorName, COUNT(*) AS InvoiceQty,    SUM(InvoiceTotal) AS InvoiceAvgFROM Invoices JOIN Vendors    ON Invoices.VendorID = Vendors.VendorIDWHERE VendorState < 'e'GROUP BY VendorState, VendorCity, VendorNameHAVING SUM(InvoiceTotal) > 500ORDER BY VendorState, VendorCity, VendorName; The GROUPING SETS operator works like the ROLLUP and CUBE operators, but it

Trinity College Dublin, Ireland has acquired the 150.60.130….

Trinity College Dublin, Ireland has acquired the 150.60.130.0/24 public address from the local ISP to use in its campus network. Each building has a specific number of devices that are required to be publicly accessible, as shown in the image below. Which of the following subnets would accommodate the network shown? (Select Four)