Can I do this in one select sql?

Hi everybody; I have a table like this; || NAME || IF_PURCHASED || COUNT || --- tom true5 tom false 7 tom false 3 sam true3 sam true4 sam false 2

Can I do this in one select sql?

Hi everybody; I have a table like this; || NAME || IF_PURCHASED || COUNT || --- tom true5 tom false 7 tom false 3 sam true3 sam true4 sam false 2