I previously listed the valid offers using:

```html
SELECT
    pt.prod_type_description 'Tipo do Produto',
    p.prod_brand 'Marca',
    c.comp_fantasy_name 'Nome da Empresa',
    o.offer_price 'Preco'
FROM offer                  AS o
    INNER JOIN company      AS c ON o.comp_id = c.comp_id
    INNER JOIN product      AS p ON o.prod_id = p.prod_id
    INNER JOIN product_type AS pt ON p.prod_type_id = pt.prod_type_id
WHERE 
    CONVERT(VARCHAR, o.offer_expired_at, 23) >= CONVERT(VARCHAR, dbo.datetimeBrasilia(), 23)
GROUP BY pt.prod_type_id, o.offer_price, p.prod_id, c.comp_fantasy_name, pt.prod_type_description, p.prod_brand, o.offer_id

```

But my question is how to get the cheapest product (without importance by the brand) of each type of product of each company?

```html
TYPE PRODUCT    |     BRAND     |   COMPANY     |   PRICE
----------------------------------------------------------
Cimento             Cauê     MAConstuc     13.65
Areia             AB Areias     MAConstuc     15.79
Brita             Briforte     MAConstuc     21.30
Paver PaviS     MotriX     MAConstuc     0.65
Paver Raquete     Forten     TilJola     1.20
Cimento             Votoran     TilJola     10.40
Cimento             Cauê     TilJola     14.65
Areia             AB Areias     TilJola     11.56
Brita             Briforte     TilJola      9.99
Paver PaviS     MotriX     TilJola      1.30
Paver Raquete     Forten     TilJola      1.00
Cimento             Votoran     KiCalc     22.90
Cimento             Cauê     KiCalc     20.00
Areia             AB Areias     KiCalc     18.30
Brita             Briforte     KiCalc     17.00
Paver PaviS     MotriX     KiCalc      1.35
Paver Raquete     Forten     KiCalc      0.99
```

```html
-- example of company TilJola (without Cimento Cauê)
Cimento             Votoran         TilJola         10.40
Areia             AB Areias         TilJola         11.56
Paver PaviS     MotriX         TilJola         1.30
Paver Raquete     Forten         TilJola         1.00

-- example of company KiCalc (without Cimento Votoran)
Cimento             Cauê         KiCalc         20.00
Areia             AB Areias         KiCalc         18.30
Brita             Briforte         KiCalc         17.00
Paver PaviS     MotriX         KiCalc         1.35
Paver Raquete     Forten         KiCalc         0.99
```

previously I have listed the valid offers using: