Type and execute a query that uses the CASE statement to create a column for all three names in Person.Person. When the MiddleName is NULL, nothing should be displayed for it. Name this column FullName. Also include the column PersonType.

I just need to know the correct query as if you had access to the database. I do not need to see the query itself since you may not have access to it..