I am new to SQL, where I just change my job and I need to use SQL quite frequently.

Previously, I used to work with Excel which I can easily do the following conversion from picture 1 to picture 2 by using a pivot table

[![enter image description here](https://i.stack.imgur.com/lc9Jb.png)](https://i.stack.imgur.com/lc9Jb.png)

[![enter image description here](https://i.stack.imgur.com/P3pGb.png)](https://i.stack.imgur.com/P3pGb.png)

Where I would like to work on the original data source like in picture 1,
and add a few new columns in picture 2 which correspond to each type in the dimension 'customer type'.

I would like to know to how I can achieve this in SQL.