Table: ibm_system_z10_specs
Columns: model
books_pus
ifls_uifls
zaaps_ziips
icfs
opt_saps
std_saps
std_spares
standard_memory_gb
flexible_memory_gb

Question: What is the total number of Std SAPs with 0-11 Opt SAPS?
SQL: SELECT COUNT("std_saps") FROM ibm_system_z10_specs WHERE "opt_saps" = '0-11'

Question: For Model e64 what is the zAAPs/zIIPs?
SQL: SELECT "zaaps_ziips" FROM ibm_system_z10_specs WHERE "model" = 'e64'

Question: For Model e12 what is the IFLs/uIFLs?
SQL: SELECT "ifls_uifls" FROM ibm_system_z10_specs WHERE "model" = 'e12'