Hello guys! Please help me with a little problem.
I have one table(Person) where are some values.
My current syntax is:
SELECT Status, COUNT(Name) AS Number FROM Person WHERE Status = 'Married';
But I want to get the result for each status.
That would be something like this:
How to conclude my SQL syntax and get this result?
Any help is the most welcome.