Step 1: Select rows where 'vca_155' is '40t (44.1tons)'.
| vctp |
vca_155 |
vctm |
vcpc |
vclc |
vcrt |
| 28.2 t (31.1 tons ) |
40t (44.1tons) |
26t (28.7tons) |
25t (27.6tons) |
32t (35.3tons) |
32t (35.3tons) |
| 20 mm (79in) rh - 202 autocannon |
155 mm (6.1in) l / 41 howitzer |
120 mm (4.72in) mortar |
7.62 mm (0.3in) fn mag 60 - 20 machine gun |
160 mm (6.3in) or 350 mm (13.8in) rockets |
7.62 mm (0.3in) fn mag 60 - 20 machine gun |
| km (mi) |
- |
km (mi) |
- |
km (mi) |
km (mi) |
| 24hp / t (23hp / ton) |
18hp / t ( 16.5hp / ton) |
28.8hp / t (25.1hp / ton) |
28.8hp / t (25.1hp / ton) |
22.5hp / t (20.4hp / ton) |
22.5hp / t (20.4hp / ton) |
| 75 km / h (47 mph) |
55 km / h (34 mph) |
75 km / h (47 mph) |
75 km / h (47 mph) |
75 km / h (47 mph) |
75 km / h (47 mph) |
Step 2: Select rows where 'vctm' is '28.8hp / t (25.1hp / ton)'.
| vctp |
vca_155 |
vctm |
vcpc |
vclc |
vcrt |
| 28.2 t (31.1 tons ) |
40t (44.1tons) |
26t (28.7tons) |
25t (27.6tons) |
32t (35.3tons) |
32t (35.3tons) |
Step 3: Select rows where 'vctp' is '155 mm (6.1in) l / 41 howitzer'.
| vctp |
vca_155 |
vctm |
vcpc |
vclc |
vcrt |
Step 4: Select rows where 'vcpc' is '120 mm (4.72in) mortar'.
| vctp |
vca_155 |
vctm |
vcpc |
vclc |
vcrt |
Step 5: Use a `CASE` statement to return TRUE if the number of rows for each step is equal to 1, otherwise return FALSE.
| vctp |
vca_155 |
vctm |
vcpc |
vclc |
vcrt |