Combine lines with same identifier

[Anonymous]

Hello

I attached you a SQL table I've. I collect the data from a tool used in Factory.

I've an issue, I explain it :

As you can see, I've some Reception Numbers equals, with a Net Weight Plant equals, and differents Net Weight Palette.

The tool create a line / Palette, and calculate a Net Weight Plant with the SUM of Net Weight Palette and apply a formula. Some time the Net Weight plant is different from the SUM of Net Weight Palette.

I would like to :

- Aggregate the lines with same reception number

- Keep the Net Weight Plant value

- apply a COUNT on the Net Weight Palette

(in order to obtain a Palette AVG)

I dont know If I've to do it in the SQL request ? Or if it can be done in a set analysis ?

And I've no idea how to do it

Thanks for your help

REgards