Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL, All the scripts are attached