4. (25 points) Write an SQL statement to display the very middle character of their first...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. (25 points) Write an SQL statement to display the very middle character of their first names for all employees whose first names have odd number characters (e.g., 3, 5, 7, etc.). The titles of the two displayed columns are "First Name" and "Middle Character of First Name". No special sorting needed. First Name Middle Character of First Name 1 Neena 2 Lex e 3 Alexander a 4 Bruce 5 Diana a 6 Kevin V 7 Randall d 8 Peter t 9 Eleni e 10 Ellen 1 11 Kimberely e 12 Michael h 13 Pat a 14 Shelley 1 15 William 1 4. (25 points) Write an SQL statement to display the very middle character of their first names for all employees whose first names have odd number characters (e.g., 3, 5, 7, etc.). The titles of the two displayed columns are "First Name" and "Middle Character of First Name". No special sorting needed. First Name Middle Character of First Name 1 Neena 2 Lex e 3 Alexander a 4 Bruce 5 Diana a 6 Kevin V 7 Randall d 8 Peter t 9 Eleni e 10 Ellen 1 11 Kimberely e 12 Michael h 13 Pat a 14 Shelley 1 15 William 1
Expert Answer:
Answer rating: 100% (QA)
To display the very middle character of the first names for employees whose first names have ... View the full answer
Related Book For
Database Processing Fundamentals, Design, and Implementation
ISBN: 978-0133876703
14th edition
Authors: David M. Kroenke, David J. Auer
Posted Date:
Students also viewed these programming questions
-
A random variable, x, has a normal distribution with m = 13.6 and s = 2.90. Determine a value, x0, so that P (X
-
Sales price per unit: $450 Variable cost per unit: $210 Average production: 1,000 units per month Total fixed costs: $187,000 per month How many units must Key sell in order to make a profit of...
-
1. Write an SQL statement to list the reservation ID, trip date, and total trip cost for all reservations. The total trip cost can be calculated by multiplying the trip price times the number of...
-
Workplace stress is sometimes related to time management. Describe a time when you were stressed at work or school because of time management. Explain how you would advise an employee or student to...
-
Consider the following three statements: i. You can either stand during a college football game or you can sit. You believe that you will see the game very well if you stand and others sit but that...
-
The two axes of an xy positioning table are each driven by a stepping motor connected to a Leadscrew with a 4:1 gear reduction. The number of step angles on each stepping motor is 200. Each Leadscrew...
-
The owner of a business introduced new capital of 8,000 during the year and withdrew 2,500 cash for his private use. The profit earned by a business in 2008 was 68,500. If the net assets at the...
-
1. After taking into account the income that Sophia will receive from Social Security and her company sponsored pension plan, the financial planner has estimated that her investment assets will need...
-
Cash Flows from Investing Activities During the year, Roberts Company sold equipment with a book value of $140,000 for $190,000 (original purchase cost of $240,000). New equipment was purchased....
-
Construct an optimal binary search tree for five keys A, B, C, D, E with probabilities p1 = 0.1, p2 = 0.3, p3 = 0.1, p4 = 0.4, p5 = 0.1. Show(1) the main table; (2) the root table; (3) all...
-
Presented below is information related to equipment owned by Coronado Company at December 31, 2025. Cost $10,080,000 Accumulated depreciation to date 1,120,000 Expected future net cash flows Fair...
-
Colt Company produces two skateboard models. Machine time per unit for Hero is two hours and for Flip is one hour. The machine's capacity is 1,980 hours per year Colt can sell up to 728 units of Hero...
-
Suppose ABC Inc. has the following properties: Constant Debt Level of $ 2 1 , 0 0 0 Marginal tax rate of 2 2 . 0 0 % Long - term growth rate of 2 . 0 0 % Cost of debt 4 . 0 0 % What is the Value of...
-
Cumberland County Senior Services is a non-profit organization devoted to providing essential services to seniors who live in their own homes within the Cumberland County area. Three services are...
-
Splish Company has accounts receivable of $163,400 at March 31. An analysis of the accounts shows the following. Month of Sale Balance, March 31 March $99,200 February 35,280 January 18,200 Prior to...
-
Gonzalez Company is considering two new projects with the following net cash flows. The company's required rate of return on investments is 10%. (PV of $1. EV of $1, PVA of $1, and FVA of $1) (Use...
-
Funds are separate fiscal and accounting entities, each with its own self-balancing set of accounts. The newly established Society for Ethical Teachings maintains two funds-a general fund for...
-
Discuss the effect on setting performance bonuses for staff if financial performance for a period contains both realised and unrealised gains/losses.
-
Financial statements should reflect realistically the performance and position of an organisation, but most of the accountant's rules conflict directly with the concept of realism. Discuss.
-
Explain why financial reports prepared under the historical cost convention are subject to the following major limitations: inventory is undervalued the depreciation charge to the income statement...
Study smarter with the SolutionInn App