How to make query in query in mysql?

Question

MySQL

there is such a table 'table'
|id |id_2|name|status| date|
it is necessary that, when requested, it displays where status = true, and count_id = number of id for 30 days.
|id|id_2|name|status|date| count_id |
I can only do this
select * from table where status=true ; And how to add an additional column count id where it asks for the number of id in 30 days?

Answer 1

Тебе поможет подзапрос https://metanit.com/sql/mysql/4.8.php и функция count https://oracleplsql.ru/mysql-function-count.html