Counting post and changing roles in mysql database. Query not code

Counting post and changing roles in mysql database. Query not code

tech