Mamadorunrun7646 Mamadorunrun7646
  • 14-09-2019
  • Computers and Technology
contestada

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

Respuesta :

wein7145 wein7145
  • 14-09-2019

Answer:

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.

Answer Link

Otras preguntas

Carol Singer had a previous balance of $557.83 in her checking account. She deposited checks totaling $882.84, made cash withdrawals of $325.00, and wrote check
Whats a good way to remember numbers in french?
Identify three fields of scientific study that can be used to gather new knowledge necessary to make appropriate management decisions
Life on a ship short essay
of the pupils in Year 9 say their favourite colour is red There are 75 pupils in Year 9. How many students said red is their favourite colour?
Sameen bought 2 and 1/5 pounds of carrots for $6.60. At that rate, how much would 1 pound of carrots cost?
What is the name for the number of species that live in an ecosystem
Hope uses the equation C = 3h + 9 to find the total cost c in dollars or renting a bike for h hours if hope does not spend more than $30 what is the maximum num
List 6 ways intoxication can affect a person.
How do communities define their identities?