How to turn a vertical table into a horizontal one in sql? Can u write a code?

Question

C_Firstname D_Birthday
John 01.02.1995
David 13.10.1999
Chloe 09.09.2000
Emily 25.06.1995
James 29.12.2002
Victor 14.08.2001
Mary 15.06.1996

Answer 1

Yes, I tried, but it didn't work out

Answer 2

Ok, thanks