I tired to googling this issues every time I need to create some test instance with MySQL (MariaDB) on Linux ))

That is all!

I need help 🙂

What we have:

1. The table A with next columns:

asset – VARCHAR
decimals – INT
description – VARCHAR

2. The table B with next columns:

asset – VARCHAR
price – VARCHAR
amount – VARCHAR
order – VARCHAR (unique)
type – VARCHAR (may be ‘ask’ or ‘bid’ value only)

What I need to get:

For any asset ID I need next information:

asset
decimals
description
min price from table B if type = ask and the same asset
sum for min price
max price from table B if type = bid and the same asset
sum for max price

Right now I have three different sql query for this result. I tried to create some view. It didn’t work for me.

Who can help me? 🙂

P.S. Don’t ask me about VARCHAR ))
P.P.S. MySQL