Question: Write the SQL that will retrieve the following results: Consultants Table Fname Lname HireDate Position Bella Agostino 11/12/2019 Developer John Perry 2/17/2016 Network Engineer Jessica

Write the SQL that will retrieve the following results:

Consultants Table

FnameLnameHireDatePosition
BellaAgostino11/12/2019Developer
JohnPerry2/17/2016Network Engineer
JessicaMurdoch9/5/2015Developer


From the Consultants Table below, identify the 3 most recently hired employees.  Show their First Name, Last Name, Hire Date, and Position in the results.

Consultants Table

EmployeeIDFnameLnameSalaryHireDatePosition
1JessicaMurdoch950009/5/2015Developer
2WesleyMann820008/9/2012Developer
3JohnPerry870002/17/2016Network Engineer
4HemantBabtiwale940005/23/2014Network Engineer
5JeffersonYoakum1250006/15/2011Project Manager
6ConnorFairchild1140003/4/2015Specialist
7BellaAgostino10500011/12/2019Developer
8SonNguyen1020001/5/2014Business Analyst
9AmandaSanAngelo1200001/7/2010Project Manager
10DougLokker1190003/15/2012DBA

Step by Step Solution

★★★★★

3.54 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To get the information about the 3 most recently hired employees from the Consultants Table ... View full answer

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!

Q:

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Q:

1- Retrieve the department ID, department name, location ID, and city for each department from the HR schema. Hint: use natural join 2-...

Q:

Get the data up to date. So run the following 3 statements to update the data to a more current timeline: UPDATE employees SET hire_date = hire_date + (20*365); UPDATE job_history SET end_date =...

Q:

Q2(a) i. The Lyons Dance Company uses the following database that stores data about ballet dancers, shows and companies. COMPANY(compID, compname, city, country) DANCER(dancerID, dname, birthyear,...

Q:

Q2(a) The Lyons Dance Company uses the following database that stores data about ballet dancers, shows and companies. COMPANY(compID, compname, city, country) DANCER(dancerID, dname, birthyear,...

Q:

/* CREATE_P_V.SQL */ /* Introduction to SQL */ /* Script file for ORACLE DBMS */ /* This script file creates the following tables: */ /* V - default vendor table data */ /* P - default product table...

Q:

Problem: Northwind Traders is a leading international supplier of food and beverages. They have an extensive network of suppliers around the world and customers spread across different countries....

Q:

I need it as soon as possible please CS346 A5.5: Due Apeil 5 L Ghemei Download the CREATE_P_v.sql file from dropbox Make sure not to delete any working query as you answer more questions Once all...

Q:

1. Write the SQL query to retrieve the following information of all employees: a. Employee number b. Employeelastname c. Date of hire d. Jobcode. The company wants to send a check to their employees...

Q:

SQL Practice - Submit SQL statements Using the tables (cs3350.branches, cs3350.transactions, cs3350.employees, cs3350.customers) CS3350.EMPLOYEES ( EMPLOYEE_ID NUMBER, BRANCH NUMBER, FIRST_NAME...

Q:

1. What are the benefits of implementing an HR Scorecard/Dashboard. Should it be balanced? Why or why not? 2. Identify at least two possible competitive advantages that might result from using an HR...

Q:

The Procter & Gamble Company. The 2019 annual report of The Procter & Gamble Company (P&G) is available at www.pginvestor.com. After reviewing P&Gs annual report, respond to the...

Q:

Express the repeating decimal as the ratio of two integers. 0 . 1 8 overbar = 0 . 1 8 1 8 1 8 . . .

Q:

when enaging in class- cultural communication, there are six fundamental patterns of culture differences. Explain five of them and provides example

Q:

Revenue and expense data for Bluestem Company are as follows: Year 2 Year 1 administrative expenses 37,720 20,300 COGS 360,000 319,900 Income tax 41,000 32,200 Sales 820,000 700,000 Selling expense...

Q:

Discuss the characteristics of "emotional intelligence" and how these characteristics play a key role in bringing the competencies needed from today's desirable manager.

Q:

As part of cultural leadership ,there are four important culture- based norms and beliefs which need to be considered. Explain each type of culture-based norms and beliefs and provide appropriate...

Q:

Identify the competitive behaviour responses of Tesco to build or defend its competitive advantages and to improve its market position.)

Q:

Which aspect of business letters is different from that of business emails?Multiple ChoiceOrganizationWriting styleLengthFormat

Q:

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a...

Q:

The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...

Q:

Write the SQL command to revoke user Stetsons privilege.

Q:

Continuing with the ECCO company from Problem 4-76, when a customer returns one of the alarms under warranty, the quality manager logs data on the product. From the data available in the Ecco file,...

Q:

Long-time friends Pat and Tom agree on many things, but not the outcome of the American League pennant race and the World Series. Pat is originally from Boston, and Tom is from New York. They have a...

Q:

PricewaterhouseCoopers Saratoga, in its 2005/2006 Human Capital Index Report, indicated the average number of days it took for an American company to fill a job vacancy in 2004 was 48 days. Sample...