I'll answer by email to all your questions. I have more than 20 years of experience with RDBMS - MS SQL Server, MS Access, Oracle, Informix etc. I can explain you everything about SQL statements and their syntax, stored procedures, views, triggers, transactions, isolation levels of transactions, tables, indexes, primary keys, foreign keys, constraints etc.
I can write any SQL statement that you need! You just have to give me the structure of database, i.e. sturcture of the tables with PK, FK and indexes.
If you have additional requirements to the result you want to receive, we can negotiate.