1.Create a SQL query that shows the first_name, last_name, hire_date, and the nu
ID: 3755474 • Letter: 1
Question
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 don’t 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”
Explanation / Answer
1. Answer :
2. Answer :
3. Answer :
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.