1. Create a SQL query that shows the first_name, last_name, hire_date, and the number of days that the employee has worked from the EMPLOYEES table. Use the concatenation operator to put the first_name and the last_name together in the same column in the result set with a space between the two names. Use date arithmetic to show only employees that have worked longer than 6 years (365 * 6).

2. You have been asked to create a report showing the intra-office contact information. Create a SQL query using the EMPLOYEES table that shows the employee_id, first name, last name, email address as email@itresources.com and the last 4 digits of the phone number, usually referred to as the phone line number. Only show employees that dont have a job ID like AD_ anything.

Use the CONCAT() function, as opposed to the concatenation operator used above to put the email besides @itresources.com

3. Modify the previous SQL query and add the phone_number to your result set as we are used to seeing it: (xxx)xxx-xxx. The easiest way to do this is to use a combination of the concatenation operator|| with the substr() function to get the digits from the phone_number based on their position and length. Use a column alias to show the new format phone number AS Usual phone number

Please read carefully in the instructions. Previous experts are getting it wrong and will not respond to my comments

IE EMAIL PHONELINE AHUNOLD@itresources.com BERNST@itresources.com DAUSTIN@itresources.com 4567 4568 4569