[Issue] fixing arguments for method in getStatusByState

[m2-assistant]

This issue is automatically created based on existing pull request: #30172: fixing arguments for method in getStatusByState

---

Summary (*)

Magento 2.4-develop
if you will checking this condition
echo $select = $this->getConnection()->select() ->from(['sss' => $this->stateTable, []]) ->where('state = ?', $state) ->limit(1) ->columns(['status']);
then you see
SELECT sss.*, sss.statusFROMsales_order_status_stateASsss WHERE (state = 'complete') LIMIT 1
but method getStatusByState return is correct value - because the status of a certain state should return. But if this code is rewritten to get the state, then we will also get the status, this is all due to the incorrect parameter in the from method

Examples (*)

1. echo $select in getStatusByState method should return sql like this
   SELECT sss.statusFROMsales_order_status_stateASsss WHERE (state = 'complete') LIMIT 1

Proposed solution