Question: 3- Generate a report to display full name, length (number of characters) of full name, hire day and hire date for all staff members

3- Generate a report to display full name, length (number of characters) of full name, hire day and hire date

3- Generate a report to display full name, length (number of characters) of full name, hire day and hire date for all staff members who earn a commission and do not hold the job title "SA_MAN". Rename the columns accordingly and format the report as shown in the table below: Full Name Name Length Peter Tucker David Bernstein Peter Hall Christopher Olsen. 11 Char. 14 Char. 9 Char. 16 Char. Hire Day Hire Date Thursday January Monday March Wednesday August Monday March 30th 1997 24th 1997 20th 1997 30th 1998

Step by Step Solution

★★★★★

3.30 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Heres the SQL query for given Data CREATE TABLE employees1 employeeid INTEGER PRIMARY KEY firstname ... View full answer

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 Programming Questions!

Calculate the theoretical density of Si. Assume Si has the diamond cubic structure, the atomic radius is 1.176 A, and the atomic mass is 28.08. Use Avogadro's number of 6.022 1023 (Enter your answer...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Given: A 1-kg, AISI 1070 high-carbon steel is being cooled slowly to the following temperatures (a) 800 C; (b) 728 C; and (c) 726 C Find: Determine the amount of gamma, alpha and cementite phases in...

Generate a report to display full name, length (number of characters) of full name, hire day and hire date for all staff members who earn a commission and do not hold the job title "SA_MAN". Rename...

could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting theory. I...

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

Hi need to get done only one article from the given ones but please choose any one except article no 2 as i have already done that one. please choose right theory and apply it on the article and...

i need to get any one article any one can help with any other article done just except second one as its already been done 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1...

two articles needs to be done according to the given requirement in the attatched file 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1 2016 A. OVERVIEW The research...

Consider Figures 1 and 2. Which of the following are accurate conclusions? The gender wage gap is lower when we include control variables. The gender wage gap increases as a woman ages through her...

How often do you show conformity in your behaviour? What are the determinants of conformity?

Learn It ! 2 - 6 Total points: - - / 4 Attempts left: 1 0 Which of the following are ways that a company choosing a cost competitive advantage can reduce costs? ( Select three ) Utilizing technology...

Starfleet Corporation has one temporary difference at the end of 2021 that will reverse and cause taxable amounts of $55,000 in 2022, $60,000 in 2023, and $75,000 in 2024. Starfleets pretax financial...

Sales representatives should act as if they were on the customers payroll. Evaluate this statement by explaining in your own words what it means and by describing the advantages and disadvantages...

The ? goodwill ? footnote for American Oriental Bioengineering 2011 10K is shown below. When firms make acquisitions, the goodwill recorded in an acquisition must be assigned to a reportable segment....

The uniform 40-lb bar with attached 12-lb wheels is released from rest in the orientation shown. The wheels have a centroidal radius of gyration of 4.5 in., and the coefficients of static and kinetic...

The Coriolis force determines the directions of the trade winds, mid latitude Westerlies, and Polar Easterlies as described in the text. What about the strength of these winds? How, for example,...

Which of the following skills is NOT required for solving conservation tasks? Decentration ISendity Thereforty Sertation

Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...

Ken (age 31) and Amy (age 28) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of these items must be used to...

Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...

One of the fust Internet-based groceries home delivery businesses was Homegrocer.com. In 1998, Mike Donald, president of Concord Sales, one of the largest food brokers in B.C., and two partners...

Go to the Web site of Airbus A38G, the biggest passenger plane ever built (525 passengers or more on 2 floors, with a range of 15,000 km, and a wingspan of 80 metres), http://www.airbus....

The fixed cost of running a gift store (wages, rent, etc.) in a particular mall is $250,000 per year. The gross margin (i.e., sales - cost of goods sold or alternatively revenue - variable cost) is...