Table: navy_training
Columns: serial_branch
seaman
mechanical
secretariat
supply
electrical
radio_electrical
regulating
medical

Question: How many serial branches have radio electrial = rea-iv?
SQL: SELECT COUNT("serial_branch") FROM navy_training WHERE "radio_electrical" = 'REA-IV'

Question: What are radio electricals when secretariat is wtr i?
SQL: SELECT "radio_electrical" FROM navy_training WHERE "secretariat" = 'WTR I'

Question: What are electricals where secretariat is po(w)?
SQL: SELECT "electrical" FROM navy_training WHERE "secretariat" = 'PO(W)'

Question: What mechanical has lpm regulation?
SQL: SELECT "mechanical" FROM navy_training WHERE "regulating" = 'LPM'

Question: How many branches have radio electrical=hon s lt(r)?
SQL: SELECT COUNT("serial_branch") FROM navy_training WHERE "radio_electrical" = 'Hon S Lt(R)'

Question: Who regulates radio electrical = lren?
SQL: SELECT "regulating" FROM navy_training WHERE "radio_electrical" = 'LREN'