Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > create table t ( > f1 numeric(10,3), > f2 numeric(10,3), > f3 numeric(10,3), > f4 numeric(10,3) > ) > > <pre> > ✓ > </pre> <!-- --> > insert into t values ( 60, 60, 60, 60 ); > > <pre> 1 rows affected > </pre> <!-- --> > select * from t; > > <pre> > F1 | F2 | F3 | F4 > :----- | :----- | :----- | :----- > 60.000 | 60.000 | 60.000 | 60.000 > </pre> <!-- --> > select f1*f2*f3*60 as product from t > union all > select f1*f2*f3*f4 as product from t; > > <pre> > | PRODUCT | > | :------ | > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=firebird_3.0&rdbms2=firebird_3.0&fiddle=71ab81a3cc373d6fa6be75ddcc078f18)*
back to fiddle