If this is a query that is used repeatedly, a shorthand method of reusing this query without re-typing the entire SELECT command each time is to create a view as shown below.
The view name, employee_pay, can now be used like an ordinary table name to perform the query.
Making liberal use of views is a key aspect of good SQL database design. Views provide a consistent interface that encapsulate details of the structure of your tables which may change as your application evolves.
Views can be used in almost any place a real table can be used. Building views upon other views is not uncommon.