Oracle SQL samll project

There are some questions(instructions) related to Sql - Pl/Sql subject. I provide you the materials and you should give me the results in 2 files (.sql format as code lines and .txt format as the result display).
You should have installed "Oracle database" software and run the code through "Run Sql Command Line" application