Magento 2 core connect select the row and rename field and also performed sum minus all conditions

 Certainly! Based on your requirements, here’s an updated code snippet that performs the sum and subtraction of two fields with conditions applied:

phpCopy code
$select = $adapter->select()
    ->from(
        ['c' => $tableName],
        [
            '*',
            'sum_field' => new Zend_Db_Expr('c.qty + c.sale_qty'),
            'diff_field' => new Zend_Db_Expr('c.qty - c.sale_qty')
        ]
    )
    ->where('c.qty > ?', $qtyThreshold) // Apply a condition on c.qty field
    ->where('c.sale_qty > ?', $saleQtyThreshold); // Apply a condition on c.sale_qty field

In the above code, I’ve added two new aliases, sum_field and diff_field, to represent the sum and subtraction of qty and sale_qty fields, respectively. Additionally, I’ve included conditions on both qty and sale_qty fields using the where() method. Please replace $qtyThreshold and $saleQtyThreshold with your desired values for the conditions.

Make sure to replace $adapter with your database adapter instance and $tableName with the actual name of the table you are querying.

After executing the select query, you can retrieve the result using the aliases sum_field and diff_field from the query result.