Table: tank_specs
Columns: vctp
vca_155
vctm
vcpc
vclc
vcrt

Question: If there is a VCPC of 75km/h (47mph) what is the VCA?
SQL: SELECT "vca_155" FROM tank_specs WHERE "vcpc" = '75km/h (47mph)'

Question: If there is a VCRT of 7.62mm (0.3in) fn mag 60-20 machine gun, what is the VCTP of that?
SQL: SELECT "vctp" FROM tank_specs WHERE "vcrt" = '7.62mm (0.3in) fn mag 60-20 machine gun'