SQL

For this practice we are going to use WORLD database from mysql.com. you can download from here: https://dev.mysql.com/doc/index-other.html    Subqueries and Correlated Subqueries: SQL subqueries are nested queries placed inside another query, allowing you…