Skip to content
Advertisement

How to find how many times X appears

Learning SQL using SSMS and I have been given a database and a 32 questions. I am working my way through the questions and got suck on a question of “How many people live in each city?” I know how to get how many times a singular entry is but not multiple.

Table:

Insert’s:

Advertisement

Answer

You can concatenate both the First name and Last name of the peoples to find the total Count

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement