Hi,
here is your example according to the description.
A database has been created and a new procedure for rotating a table from a database has been created.
The most difficult part of your task has been created. The rest is a field for your creativity and experimentation. )
A few notes:
-You need to create a form to add / edit database records, dictionary tables (year, grade, empinfo).
-The final result in table 2 and the report is desirable to use as the final report. You may have some difficulty
editing records when trying to directly invoke a record for editing. Use table1 for testing
-The report button can be deleted. In the future, everything can be returned.
-The SQL query (script) is written on the basis that for each employee, in each year there can be only one rating.
Which means that when changing the rating in any year, the record must be edited and not a new record added.
I know there are training courses in the Russian part of the forum, but this is probably not relevant for you.
Maybe someone else can tell you.
In fact, starting with a simple one, you can study it yourself.
Training materials can be found on the forum.
Examples on the forum.
Additional SQL resources on the Internet (sqlitetutorial).
And of course questions on the forum (only specific questions) if you have not found the answer yourself.
Post's attachments Perform.zip 337 kb, 240 downloads since 2022-01-04