I need to have three sperate sql scripts one for each part of the assignment. Ex

I need to have three sperate sql scripts one for each part of the assignment. Explanations of each would be helpful. DO NOT combine the code for all three parts into one-I am a novice in SQL and this assignment needs to show progress from part 1-3.THe best way for me to do this will be to submit the sample table outputs and descriptions of the project the professor is looking for these scripts to produce.I am a network engineer not a coder or developer-thats the only reason I am here. I need these reports to run fully functional without making the code look overly complex. The teacher will know I did not produce it if it is to complex. I also need to show explanations of the code in SIMPLE TERMS.