How to check salary increase in Cloud using SQL

Summary:

How can we check salary increases on a specific date in HCM Cloud using SQL? Does anyone have a sample query they can share, or guidance on the key tables involved (such as CMP_SALARY, etc.)? Any direction or best practices would be appreciated.

Also, is there a seeded report available that shows salary increases on a particular date?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

25D

Code Snippet (add any code snippets that support your topic, if applicable):