Table: network_devices
Columns: vendor_and_type
models
netflow_version
implementation
comments

Question: How many netflow version are there when the vendor and type is enterasys switches?
SQL: SELECT COUNT("netflow_version") FROM network_devices WHERE "vendor_and_type" = 'Enterasys Switches'

Question: What are the comments when the  vendor and type is alcatel-lucent routers?
SQL: SELECT "comments" FROM network_devices WHERE "vendor_and_type" = 'Alcatel-Lucent routers'

Question: What are the comments when vendor and type is enterasys switches?
SQL: SELECT "comments" FROM network_devices WHERE "vendor_and_type" = 'Enterasys Switches'

Question: What is the netflow version when vendor and type is pc and servers?
SQL: SELECT "netflow_version" FROM network_devices WHERE "vendor_and_type" = 'PC and Servers'

Question: What are the comments when the implementation is software running on central processor module?
SQL: SELECT "comments" FROM network_devices WHERE "implementation" = 'Software running on Central Processor Module'

Question: What is the implementation when the netflow version is v5, v8, v9, ipfix?
SQL: SELECT "implementation" FROM network_devices WHERE "netflow_version" = 'v5, v8, v9, IPFIX'