-
Write a query that returns data on active sessions in the database (MySQL)
-
Check the status of MySQL replication
-
Get information on the maximum number of connections to the database
-
There is a table with a structure to which you need to write queries:
- a) select all user dialogs with ID = 12345
- b) select all user dialogs with ID = 12345 for the last week where there are new messages
- c) count the number of all user dialogs with ID = 12345
- d) select 10 users with more than 10 dialogs
- e) select the top 10 users by the number of conversations