SQL : How do I count only the first occurrence of a value?

SQL : How do I count only the first occurrence of a value?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a secret feature that I want to reveal to you.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
Then, type the letters 'awesome' on the keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

An introduction to myself in a few words,
Hi, my name is Delphi, nice to meet you.
Let me help you get the answers you need to your questions.
SQL : How do I count only the first occurrence of a value?
If you need more specific information, let me know by leaving a comment or starting a chat.
Your thoughts and contributions are welcome, so please leave a comment below if you have an answer or insights to the answer.
I will express my appreciation for your answer by 'hearting' it.
of value? How a first occurrence count SQL : do only the I