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).

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

4. 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

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