```
CREATE TABLE Purchase_payment
(  
     supplier_id int 
         foreign key references purchase_supplier_master_details(supplier_id)
                 on delete cascade
                 on update cascade,
     stock_name varchar(25),
     QUANTITY INT NOT NULL,
     Currency_type VARCHAR(15),-----FOR BOTH NATIONAL AND INTERNATIONAL SUPPLIER
     COSTING_Amount INT NOT NULL,
     INTERVALS INT,
     PERMONTH_PAYMENTS INT,
     PAYMENT_MODE VARCHAR(25) NOT NULL,
     PAID VARCHAR(5),

     CONSTRAINT PAID CHECK (PAID = 'YES' OR PAID = 'NO')
)

```

My query:

```
select 
    supplier_id,
    stock_name,
    QUANTITY,
    Currency_type,
    COSTING_Amount as "Discounted_amount",
    case
       when  supplier_id= 41256 and Currency_type ='RUPEE' 
          then COSTING_Amount=(COSTING_Amount-0.25*COSTING_Amount) as "Discounted_amount",
       when supplier_id=41257 and Currency_type='RUPEE'
          then COSTING_Amount=(COSTING_Amount-0.50*COSTING_Amount) as "Discounted_amount"
       else 'no discount'
    end 
from Purchase_payment

```

This query is valid only when currency is rupee. In purchase table there is also euro and pound so different for scenario can you add all currency conversion in single case statement?