How to display records with a unique value in MYSQL field?

Hello.

Write logging for the site. Record the ip_address with the domain.
Work:
id | ip_address | domain | date

How do I to display the number of unique records in the field ip_address domain.

An example of what I expect:
domain | unic_views
test.ru | 15

Thanks in advance.
April 4th 20 at 00:54
1 answer
April 4th 20 at 00:56
Group by
I understand that group by, I need a specific request, otherwise I would not have painted the table structure - Kelley40 commented on April 4th 20 at 00:59
@Kelley40, it's a mission, not a question - daisha2 commented on April 4th 20 at 01:02
@Kelley40, ₽to 5000 - loma.Howell73 commented on April 4th 20 at 01:05
@loma.Howell73, man, I'm not sure you understand SQL already decided long ago. If you know about something I would write. - Kelley40 commented on April 4th 20 at 01:08
@Kelley40, is the answer to the question. He is above and free.
If you need a ready code, that is the solution to your working tasks - it's worth the money. - loma.Howell73 commented on April 4th 20 at 01:11
@loma.Howell73why you're writing something. I already said that he solved this problem. - Kelley40 commented on April 4th 20 at 01:14

Find more questions by tags MySQL