MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE goods(no integer PRIMARY KEY, original_price float, price float);
insert goods values (1,3990,1590);
insert goods values (2,1990,1590);
insert goods values (3,990,0);
select *
from goods
order by no


no
original_price
price


1
3990
1590

2
1990
1590

3
990
0


select min(tempprice) as price_min,max(tempprice) as price_max
from (
select case when price=0 then original_price else price end as tempprice
from goods
) as TableA


price_min
price_max


990
1590