Write the SQL that will retrieve the following results: Consultants Table Fname Lname HireDate Position Bella Agostino
Fantastic news! We've Found the answer you've been seeking!
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 | Murdoch | 9/5/2015 | Developer |
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
EmployeeID | Fname | Lname | Salary | HireDate | Position |
1 | Jessica | Murdoch | 95000 | 9/5/2015 | Developer |
2 | Wesley | Mann | 82000 | 8/9/2012 | Developer |
3 | John | Perry | 87000 | 2/17/2016 | Network Engineer |
4 | Hemant | Babtiwale | 94000 | 5/23/2014 | Network Engineer |
5 | Jefferson | Yoakum | 125000 | 6/15/2011 | Project Manager |
6 | Connor | Fairchild | 114000 | 3/4/2015 | Specialist |
7 | Bella | Agostino | 105000 | 11/12/2019 | Developer |
8 | Son | Nguyen | 102000 | 1/5/2014 | Business Analyst |
9 | Amanda | SanAngelo | 120000 | 1/7/2010 | Project Manager |
10 | Doug | Lokker | 119000 | 3/15/2012 | DBA |
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: