Query help

[panix panix]

Good morning,
Thanks to all can help me.

I have this table:

__________________________________________
DATE | VALUE | TYPE
__________________________________________
2023-01-01 | val1 | Type1
__________________________________________
2023-01-01 | val2 | Type2
__________________________________________
2023-01-01 | val3 | Type3
__________________________________________
2023-01-02 | val4 | Type1
__________________________________________
2023-01-02 | val5 | Type2
__________________________________________
2023-01-02 | val6 | Type3
__________________________________________

It continues in the same way


I'd like to realize a query that show me this table:


DATE | VALUE
_____________________________________________________
2023-01-01 | (val1 * A) + (val2 * B) + (val3 * C)
_____________________________________________________
2023-01-02 | (val4 * A) + (val5 * B) + (val5 * C)

Where A, B, C are 3 constants and selecting the values with the type column.

Can anyone help me?
Thanks