3- Generate a report to display full name, length (number of characters) of full name, hire...
Fantastic news! We've Found the answer you've been seeking!
Question:
![3- Generate a report to display full name, length (number of characters) of full name, hire day and hire date](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/answers/2023/10/651d8dd1a4aff_665651d8dd1a0749.jpg)
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Heres the SQL query for given Data CREATE TABLE employees1 employeeid INTEGER PRIMARY KEY firstname ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these 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...
-
Canton Company makes two types of cell phones. Handy is a thin, pocket-size cell phone that is easy to carry around. Action is a palm-size phone convenient to hold while the user is talking. During...
-
In Chapter 3, we defined a negative binomial rv as the number of failures that occur before the rth success in a sequence of independent and identical success/failure trials. The probability mass...
-
A taxpayer owns 100,000 shares of Microsoft Corporation, currently valued at $ 10 million. The taxpayer purchased the stock for $ 10 per share and thus has an unrealized gain of $ 9 million. The...
-
Hagia Electronics, Inc., operates a chain of consumer electronics stores in the Dallas area. This year the company achieved annual sales of $75 million, on which it earned a net income of $3 million....
-
Be You Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Each project requires an investment of $480,000. A rate of 15% has been...
-
7. Find the parametric equations for the line through the points P(1, 2, 5) and Q(3, -2, 1)
-
In the Millikan oil-drop experiment illustrated in the figure below, an atomizer (a sprayer with a fine nozzle) is used to introduce many tiny droplets of oil between two oppositely charged parallel...
-
Will Smith earns a salary of $ 3 , 4 0 0 per month during 2 0 2 1 . Employment Insurance taxes ( El ) are 1 . 4 5 % of the first $ 4 0 , 8 0 0 in earnings. The Canada Pension Plan ( CPP ) rate is 5 ....
-
discuss the principles of quantitative genetics and the methods used to estimate heritability, genetic correlations, and other parameters underlying the genetic architecture of complex traits?
-
What is Cognitive Psychology and explain the benefits of it?? Also, who is one of the most influential people in cognitive psychology? The simplicity of this video in explaining cognitive psychology...
-
The speed limit for vehicles on a road is 100 Km/hr. A drop of 20% in the pitch of a car horn is detected by a policeman when the car passes him. Does the car driver crosses the speed limit....
-
Tall and flat organizational structures are two of the most common types of organizational structures. Conduct a research and discuss the distinction between Tall and Flat organizational structures...
-
Use the graphs to help you answer the question. Which graph represents X = Y + 1? Select one: O a. U b. T c. Q O d. Z
-
Smiths Family Fashions implemented a balanced scorecard performance measurement system several years ago. Smiths is a locally owned clothing retailer with fashions for men, women, teens, and...
-
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...
-
Waldemar Gott, a lawyer, was paid $72,000 on October 1 to represent a client in real estate negotiations over the next 12 months. 1. Record the entries required in Gotts records on October 1 and at...
-
Prepare year-end adjusting entries for each of the following: 1. Office Supplies has a balance of $168 on January 1. Purchases debited to Office Supplies during the year amount to $830. A year-end...
-
How should the general manager divide his or her time between monitoring current-year results and planning for the future?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App