Table: subnet_details
Columns: prefix_size
network_mask
available_subnets
usable_hosts_per_subnet
total_usable_hosts

Question: When the network mask is 255.255.255.252 what is the prefix size?
SQL: SELECT "prefix_size" FROM subnet_details WHERE "network_mask" = '255.255.255.252'

Question: available subnets leading total is?
SQL: SELECT MAX("available_subnets") FROM subnet_details

Question: When the network mask is  255.255.255.128 what is the lowest available subnet?
SQL: SELECT MIN("available_subnets") FROM subnet_details WHERE "network_mask" = '255.255.255.128'

Question: When the network mask is 255.255.255.224 what is the highest  total usable host?
SQL: SELECT MAX("total_usable_hosts") FROM subnet_details WHERE "network_mask" = '255.255.255.224'