For the EMPLOYEE table on page 10, show the output of the following Structured Query Language...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For the EMPLOYEE table on page 10, show the output of the following Structured Query Language (SQL) query: SELECT COUNT(*) AS Total, STORE_CODE FROM EMPLOYEE WHERE EMP_LNAME Like '%on' GROUP BY STORE_CODE HAVING COUNT(*) > 1 ORDER BY STORE_CODE; EMPLOYEE EMP CODE EMP TITLE EMP LNAME EMP_FNAME EMP INITIAL EMP DOB STORE CODE 1 Mr. W 2 Ms. T 3 Ms. R 4 Mrs. s 5 Mr. L 6 Mr. A 7 Mr. S 8 Ms. 9 Mr. 10 Mrs. 11 Mr. 12 Mr. 13 Mr. 14 Ms. 15 Mr. 16 Mr. 17 Ms. 18 Mr. 19 Mr. 20 Mr. 21 Ms. Williamson John Ratula Nancy Greenboro Lottie Rumpersfro Jennie Smith Robert Renselaer Cary Ogallo Roberto Johnsson Elizabeth Eindsmar Jack Jones Rose Broderick Tom Washington Alan Peter Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer 11 W R S Y N H U V K D S A 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 32453-3 1 1 24 3 2 3 455 4 4 A 1 3 For the EMPLOYEE table on page 10, show the output of the following Structured Query Language (SQL) query: SELECT COUNT(*) AS Total, STORE_CODE FROM EMPLOYEE WHERE EMP_LNAME Like '%on' GROUP BY STORE_CODE HAVING COUNT(*) > 1 ORDER BY STORE_CODE; EMPLOYEE EMP CODE EMP TITLE EMP LNAME EMP_FNAME EMP INITIAL EMP DOB STORE CODE 1 Mr. W 2 Ms. T 3 Ms. R 4 Mrs. s 5 Mr. L 6 Mr. A 7 Mr. S 8 Ms. 9 Mr. 10 Mrs. 11 Mr. 12 Mr. 13 Mr. 14 Ms. 15 Mr. 16 Mr. 17 Ms. 18 Mr. 19 Mr. 20 Mr. 21 Ms. Williamson John Ratula Nancy Greenboro Lottie Rumpersfro Jennie Smith Robert Renselaer Cary Ogallo Roberto Johnsson Elizabeth Eindsmar Jack Jones Rose Broderick Tom Washington Alan Peter Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer 11 W R S Y N H U V K D S A 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 32453-3 1 1 24 3 2 3 455 4 4 A 1 3
Expert 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 databases questions
-
Describe a dual relationship within ABA. Does this relationship pose an ethical dilemma? Is it unavoidable? How would you navigate this relationship? Apply Brodhead et al's decision-making model to...
-
How do cognitive-behavioral techniques, mindfulness practices, and resilience training contribute to the mitigation of stressors and the promotion of psychological well-being in high-pressure...
-
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...
-
Harley-Davidson: Preparing for the Next Century There are very few products that are so exciting that people will tattoo your logo on their body. Richard Teerlink, Retired CEO, Harley-Davidson In...
-
Gold (Au) forms a substitutional solid solution with silver (Ag). Compute the weight percent of gold that must be added to silver to yield an alloy that contains 5.5 1021 Au atoms per cubic...
-
CGK Rheosystems makes high-performance rotational viscometers capable of steady shear and yield stress testing in a rugged, compact footprint. How much could the company afford to spend now on new...
-
In order to determine how well or how badly each salesperson is performing, a sales manager needs an appraisal system. Why is this important, and what questions should such an appraisal system be...
-
Westwood Furniture Company is considering the purchase of two different items of equipment, as described below: Machine A A compacting machine has just come onto the market that would permit Westwood...
-
Craigwood Ltd acquired all the issued shares (cum div.) of Grandburn Ltd for consideration of $3,700,000 on 1 January 2023. On the date of acquisition Grandburn Ltd's Statement of Financial Position...
-
Joey, a public limited company, operates in the media sector. Joey has investments in two companies. The draft statements of financial position at 30 November 20X4 are as follows: The following...
-
4. Let G be a graph. An independent set of G is a set of nodes in G such that no two nodes in the set are joined by an edge. Define I = {(G, k) | G has an independent set with k elements }. Show that...
-
This case surrounds a dispute over decedent Stephanie Boyter Kreppeins insurance proceeds between the decedents ex-husband, Alfred Kreppein (Mr. Kreppein), and the decedents children, Ryan Brice...
-
Eastern Baby Stores, Inc., d/b/a USA Baby (EBS) appeals from a June 3, 2008 judgment entered in the United States District Court for the Southern District of New York (Preska, J.) in favor of the...
-
Hampton Island Club, LLC (the Club) is a private club on Hampton Island Preserve in Liberty County, Georgia. (Doc. 37, Attach. 1 at 8.) On July 11, 2006, Defendant Timothy Petrikin entered into a...
-
In the summer of 2005, a Pioneer representative, John Gilbert, approached the Rutherfords to discuss the possibility of leasing their property for the construction and operation of an oil and gas...
-
In this suit arising from the sale of land, we examine the appropriate measure of damages for a sale obtained through fraudulent inducement. A jury concluded that the seller of the land had failed to...
-
Cailey's Shoppe has an inventory period of 37 days, an accounts payable period of 44 days, and an accounts receivable period of 25 days. Management is considering an offer from their suppliers to pay...
-
Suppose that you are part of a virtual team and must persuade other team members on an important matter (such as switching suppliers or altering the project deadline). Assuming that you cannot visit...
-
Sally hires a maid to work in her home for $250 per month. The maid is 25 years old and not related to Sally. During 2012, the maid worked 10 months for Sally. a. What is the amount of Social...
-
Harold Conners (Social Security number 785-23-9873) lives at 13234 DeMilo Drive, Houston, TX 77052, and is self-employed for 2012. He estimates his required annual estimated tax payment for 2012 to...
-
Diego, age 28, married Dolores, age 27, in 2012. Their salaries for the year amounted to $46,479 and they had interest income of $3,500. Diego and Dolores' deductions for adjusted gross income...
-
One of the models used for predicting the severity of head injury is shown in Fig. 5.68 where \(f(t)\) denotes the force of blow to the head, \(m_{1}\) is the mass of that part of the head which lies...
-
Write the equations of motion of a multidegree-of-freedom system in matrix form using a. the flexibility matrix, and b. the stiffness matrix.
-
What is a generalized mass matrix?
Study smarter with the SolutionInn App