Your question is not clear enough.

Firstly you want a query to include the count for FloorNameID but the heading that you want to end up with do not include...

@jeff Moden that might be true....SQL-Server training takes the whole day and I might missed some of the query I should reference from .

Thank you:-)

I wrote the test again today...

@luis Cazares thank you 🙂

@Grant Fritchey thank you, I do get your concern very well and at first I was not aware that the question is missing some query calling the function but this...

@Grant Fritchey thank you,I also asked around at the office but no one knows the answer

@Grant Fritchey, yes I am aware of that.

This was a question I got in my exam and I could not answer it

@GilaMonster It was one of the question I got in my exam and I could not answer it

Thank you, that works