MS SQL select is it possible to create such a query?

Question

SQL Server

There is a database on MS SQL Server:

Microphone		Platform	Quantity

Sm58			Pivka		0
Sm91			Pivka		1
Akg414			Pivka		1
E904			Pivka 		5
Sm58			Intercon	0
Sm91			Intercon	1
Akg414			Intercon	1
E904			Intercon 	1

Is it possible to create a query to get a result like this:

Microphone	Pivka	Intercon

Sm58		0	0
Sm91		1	1
Akg414		1	1
E904		5	1

I do not quite understand where to dig, there is not enough knowledge ((((

Answer 1

select Microphone
  ,sum(case Platform when 'Pivka' then  Quantity else 0 end)
  ,sum(case Platform when 'Intercon' then  Quantity else 0 end)
from MyTable
group by Microphone

Answer 2

Using PIVOT statements .