Intermediate checkpointYou have learned subqueries, CTEs, and set operations. Let us verify your understanding with this intermediate checkpoint.Checkpoint: Intermediate checkpointLoading practice…