Count of Users Who Logged In Today?
CURRENT_DATE returns today’s date (e.g., 2025-05-24).

DATE(login_time) extracts the date from login_time.

WHERE DATE(login_time) = CURRENT_DATE filters only today’s logins.

COUNT(DISTINCT user_id) ensures we count unique users, even if they logged in multiple times.

OUTPUT

UNIQUE_USERS_TODAY:  4
Why 4? → Users with IDs 101, 102, 103, and 105 logged in on 2025-05-24.