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:
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...
-
Determine the moment of inertia for the shaded area about the y axis. Given: a = 2 in b = 4 in e y =b cos ( 2a T-HE, dy
-
Explain the process in bullet points or a flowchart: Identify financial statements and inputs required. Develop assumptions based on historical data and future expectations.
-
The interest rates in the UK and the United States are, respectively, \(4 \%\) and \(6 \%\) per annum compounded continuously. The spot price of the UK pound is \(\$ 1.6\). The forward price for a UK...
-
Kimberly Manis, an architect, organized Manis Architects on January 1, 2016. During the month, Manis Architects completed the following transactions: a. Issued common stock to Kimberly Manis in...
-
A company is projected to generate free cash flows of $429 million next year, growing at a 4.7% rate until the end of year 3. After that, cash flows are expected to grow at a stable rate of 2.6%. The...
-
Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the CREATE TABLE...
-
One particular window in the Addams' family home consists of a 75.2 cm by 69.1 cm rectangular glass window pane with a thickness of 12.3 mm. This solid glass window separates the interior of the...
-
Obihiro Group has equipment with an original cost of 500,000,000 and related accumulated depreciation of 100,000,000 on December 31, 2015. The fair value of the equipment at December 31, 2015, is...
-
On January 1, 2015, Meredith Corporation purchased 25% of the ordinary shares of Pirates Company for 200,000. During the year, Pirates earned net income of 80,000 and paid dividends of 20,000....
-
In 1988, Abraham Company completed the construction of a building at a cost of 1,900,000 and first occupied it in January 1989. It was estimated that the building will have a useful life of 40 years...
-
On May 1, 2015, Barkley Company issued 3,000 1,000 bonds at 102. Each bond was issued with one detachable share warrant. The fair value of the bonds on May 1, 2015, was 2,940,000. Instructions (a)...
-
In each of the following independent cases, the company closes its books on December 31. 1. Sanford Co. sells \($500\),000 of 10% bonds on March 1, 2015. The bonds pay interest on September 1 and...
-
What is the equivalent mass of MgSO4 (magnesium sulfate)?Formula: MM/f where: MM= molar mass and f= chemical factor
-
In a paragraph of approximately 150-200 words, analyze a film or TV/Streaming Show poster of your choosing by focusing on the ways in which representations in the poster are gendered. Include an...
-
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...
-
A company expects to receive which of the following benefits when it uses its budgeting process? a. The planning required to develop the budget helps managers foresee and avoid potential problems...
-
A direct materials budget would be used in which of the following types of companies? a. Service b. Merchandising c. Manufacturing d. All of the above
-
A disadvantage to merchants from accepting debit and credit cards would be a. lost sales. b. transaction fees. c. bounced checks. d. longer time to receive cash.
Study smarter with the SolutionInn App