List the name, department, phone number, and email address of employees with a phone number beginning with "5-".

select name, department, phone_number, email from employee e

where e. phone_number like '5-%'

Explanation:

On Chegg + SQL textbook

here we are making use of like operator to match any phone number that starts with '5-'. Like operator has two wild card that can be used with it.

(%) - -This represents zero, one or multiple characters.

(_) - - This represents a single character.