Question: Write an SQL for the following problem and take a screen shot of the output Task 2: Conversion Function 1) Display last name, first name

Write an SQL for the following problem and take a screen shot of the output

Task 2: Conversion Function

1) Display last name, first name and hire date of all employees hired before 2008. Display

the hire date in this format (example: "January 25, 2018)

2) Displays the last names of employees under the manager id 124 or 122. Also generate

an email add from getting the first 4 letters of first name of each employee.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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:

Write an SQL for the following problem and take a screen shot of the output Task 3: Group Function and Group Rows 1) Display how many employees with a salary that is less than 6000 in each job id, in...

Q:

Write an SQL for the following problem and take a screen shot of the output. (3 Marks each): Task 1: Single Row Function 1) Write an SQL statement that will display the Employee ID, Last name, First...

Q:

Write an SQL for the following problem and take a screen shot of the output. ( 3 Marks each): Task 1: Single Row Function 1. Write an SQL statement that will display the Employee ID, Last name, First...

Q:

the questions are on chegg Hello, This is Assignment 04. You have to answer questions (1 to 10) on page 163 (TAL Distributors) from your textbook (A Guide To SQL 9th Edition), Create an SQL statement...

Q:

MIS ACCESS Question. 12. For each Supplier, display the supplier Company, supplier City, Number of purchase orders placed with the supplier (give this a column heading of: Num Orders), and Submitted...

Q:

NEED HELP!!!!!! Modify the Time class of (attached) to work with Date class, Date time class and employee class. The Time object should always remain in a consistent state. Modify the Date and...

Q:

Instructions: Login to the LiveSQL workspace. Also, refer to the Oracle SQL Part 1 examples before creating these queries below. Also read Chapter 3 and study the SQL examples. Number each query you...

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

5. Create the following SQL queries using Select in the query window. Comment each step in the script. Each task must use a subquery. A. Plant the code below in your script commented as 5A-1. SELECT...

Q:

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

Q:

Discuss from research or personal experience how security has impacted your use or acceptance of e-commerce and m-commerce.

Q:

A seven-person committee composed of A, B, C, D, E, F and G is to select a chair, two vice chairs, a secretary and a treasurer. How many ways can the officers be chosen if either E is a treasurer or...

Q:

The sum of a number and its square is 2 0 . Find the number ( s ) .

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

List the forces that shape a groups decisions Explain the six-step group decision process

Q:

Describe the types of power that effective leaders employ

Q:

Describe how leadership styles should be adapted to the situation