How to retrieve information from a database?

Question

MySQL

How to display users aged 25+ for 2020 for each device.
Tell me good people)

Answer 1

Your question is not very clear. Therefore, I can assume that one of the following queries will help you:

SELECT 
  device_name,
  COUNT(*) cnt
FROM users
WHERE 
  YEAR(created_date) = 2020 AND
  year_of_birth < DATE_SUB(CURDATE(), INTERVAL 25 YEAR)
GROUP BY device_name;

execute SQL query