Question: Write a query that returns the first name, last name and phone number from all employee's whose las name ends with the letter L

Write a query that returns the first name, last name and phone

Write a query that returns the first name, last name and phone number from all employee's whose las name ends with the letter L or whose manager has an employeeid of 149 first_name Ellen Jonathon Kimberely (3 rows affected) last_name Abel Taylor Grant phone_number (011) 44 1644 429267 (011) 44 1644 429265 (011) 44 1644 429263

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The organization is setting up a new program that will operate for 3 months. The total cash funds of $180,000 from the government to operate the program. The expenses of $180,000 are allocated evenly...

The data in worksheet EXCEL Template for Question 12 with data list electrical resistance values (ohms) for 30 samples of size 5 that were taken from Babbage Chips, Inc.'s computer chip-making...

Sheridan Company produces two products: Standard and Deluxe. The company uses an activity-based costing system. Sheridan produced 9800 units of Standard and 3800 units of Deluxe. The company uses two...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

About the Database A company resells paints to customers both individual and company customers, but same data is recorded for both. The company tracks the sale of products to customers and the...

Use the following diagram to write the SQL statements below. DEPARTMENTS department_id department name manager_id location LOCATIONS location_id street address postal code city state province Country...

Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made...

Assume that you have carried out a radical chlorination reaction on (R)-2-chloro- pentane and have isolated (in low yield) 2, 4-dichioropentane. How many stereoisomers of the product are formed and...

Figure 2.24 shows a plot of velocity versus time for an object in linear motion. (a) What are the instantaneous velocities at t = 8.0 s and t = 11.0 s? (b) Compute the final displacement of the...

Which of the following statements is true of the first - in , first - out ( FIFO ) costing method? a . It includes the equivalent units and manufacturing costs in beginning work in process in the...

Passengers who travel on Qantas flights are allocated Qantas Frequent Flyer points. The entitled passengers not only derive the benefits associated with flight services they receive but they are also...

Assume you are managing partner of a law firm. Business has been slow, and you are charged with making a decision regarding which associate should be laid off. There are two contenders as follows:...

Estimating bad debts can be done by the percentage of sales method and the aging of accounts receivable method. Each method has its drawbacks and advantages. If the company you were reviewing used...

The expected level of operations in the early years of asset life is expected to be low when compared to that of later years. This may be true because of slack demand or production policies. Based on...

Sustainment is the provision of logistics, financial management, personnel services and ____________________ to maintain operations until successful mission completion. A. health service support B....

At the end of April, Hernandez Company had a balance of $37,910 in the vacation benefits payable account. During May, employees earned an additional $2,790 in vacation benefits, but some employees...

Empty Fields Company pays its salaried employees monthly on the last day of each month. The annual salary payroll for 20-- follows. Compute the following for the payroll of December 31: OASDI Taxable...

The following time card shows the time worked one week by Hal Carsom. The employer disregards any time before 8:00 A.M. or between 12:00 and 1:00 P.M. and after 5:00 P.M. Employees do not begin work...

7.57. A pool ofsix candidates for three managerial positions includes three females and three males. Table 7.26 shows the results. (a) Denote the three females by F\, F2, E3 and the three males by...

7.50. The results in Table 7.24 arc from a study16 of physical attractiveness and subjective well-being. A sample of college students were rated by a panel on their physical attractiveness. The table...

7.44. Exercise 3.6 in Chapter 3 on page 61 showed data on carbon dioxide emissions, a major contributor to global warming, for advanced industrialized nations. Is there a difference between European...