. The objective is to express the exercise statement as a SQL…