SELECT -The select-statement is the form of a query that can be directly specified in…