The data for the number employed at several famous IT companies is maintained in the COMPANY...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The data for the number employed at several famous IT companies is maintained in the COMPANY table. Write a query to print the /Ds of the companies that have more than 10000 employees, in ascending order of ID. Input Format Name ID NAME EMPLOYEES Type COMPANY. ID Integer String COMPANY Description A company ID in the inclusive range [1, 1000]. This is the primary key. A company name. This field contains between 1 and 100 characters (inclusive). Integer The total number of employees in the company. Output Format The result should contain the IDs of all the companies that have more than 10000 employees, in ascending order in the following format: Sample Input ID 1 2 3 4 5 6 7 8 9 10 1 2 7 9 COMPANY NAME Adobe Flipkart Amazon Paytm BookMyShow Oracle NIIT Samsung Sample Output TCS Wipro EMPLOYEES 28085 35543 1089 9982 5589 4003 57782 2000 10046 3500 Explanation Adobe, Flipkart, NIIT, and TCS have greater than 10000 employees, so their IDs are printed. The data for the number employed at several famous IT companies is maintained in the COMPANY table. Write a query to print the /Ds of the companies that have more than 10000 employees, in ascending order of ID. Input Format Name ID NAME EMPLOYEES Type COMPANY. ID Integer String COMPANY Description A company ID in the inclusive range [1, 1000]. This is the primary key. A company name. This field contains between 1 and 100 characters (inclusive). Integer The total number of employees in the company. Output Format The result should contain the IDs of all the companies that have more than 10000 employees, in ascending order in the following format: Sample Input ID 1 2 3 4 5 6 7 8 9 10 1 2 7 9 COMPANY NAME Adobe Flipkart Amazon Paytm BookMyShow Oracle NIIT Samsung Sample Output TCS Wipro EMPLOYEES 28085 35543 1089 9982 5589 4003 57782 2000 10046 3500 Explanation Adobe, Flipkart, NIIT, and TCS have greater than 10000 employees, so their IDs are printed.
Expert Answer:
Answer rating: 100% (QA)
You can use the following SQL query to achieve the desired re... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
Let N be a product of two distinct primes, i.e. N = p.q. Show that if N and (N) are known, then it is possible to compute p and q in polynomial time (in the bitlength of N). Hint: If you do not know...
-
Did you notice the use of 360 days representing a full year - as opposed to the alternative of 365 days in a year? Why do you think accountants use 360 instead of 365? Wouldn't that change our...
-
1) (a) How can you calculate various Capital Adequacy Ratio under Bank Regulation? Explain them. (b) State the Banking Regulation for Capital Adequacy of Banks in Saud Arabia. 2) Discuss any three...
-
Rice and Flower were partners sharing profit and loss equally. Statement of Financial Position as at 31 December 2020. Non current Assets Premises Machinery Vehicles Fittings Current Assets Inventory...
-
Demonstrate that Maxwell's equations E =- B/t and x B = 0 are compatible, i.e. the first one does not contradict the second one.
-
Groups can utilize several options for making decisions. Discuss the advantages and disadvantages of voting, consensus, and authority rule decision making.
-
Regional Hospital is a 500-bed hospital and several associated clinics in a major East Coast metropolitan area. It has been an aggressive adopter of computing technologies in efforts to decrease...
-
On December 31, 2014, when the market interest rate is 6%, OBrien Realty issues $ 800,000 of 7.25%, 10-year bonds payable. The bonds pay interest semiannually. OBrien Realty received $ 874,662 in...
-
The pressure of both tanks were 117.7 kpa.( first picture) We added 500kg mass to the left tank and the pressure went up to 118.7. (second picture) Can you explain why the pressure changed after...
-
Early in its fiscal year ending December 31, 2024, San Antonio Outfitters finalized plans to expand operations. The first stage was completed on March 28 with the purchase of a tract of land on the...
-
The basis of many signal conditioning modules is the operational amplifier. Design an operational amplifier circuit that can be used to produce an output that ranges from 0V to -5V when the input...
-
Determine the mean and standard of the binomial distribution for the variable X in each of the following: a. N = 5 and = 0.10 b. N = 5 and = 0.50 c. N = 4 and = 0.75 d. N = 3 and = 0.45
-
Is the gender of a baby a random event? Factors such as drug use, occupation, and environment may have an impact on the sex of the baby a couple is likely to conceive. For example, it has been...
-
Which of the following events occur with a probability of zero? For each, state why or why not. a. A computer system that has both Apple and Toshiba branding. b. A person who was born in January and...
-
A regional airline carrier determined that the number of kilo meters travelled per airplane per year is normally distributed with a mean of 700 thousand kilo meters and a standard deviation of a 100...
-
Given a normal distribution with = 30 and = 4, what is the probability that a. X > 38. b. X < 25. c. Find the X value such that the area to the left of X is 5% of the total area under the normal...
-
Which of the following is not a result of a tempering heat treatment..... A Improved toughness B Increased ductility C Increased electrical conductivity D Internal stresses are relieved
-
Tell whether the angles or sides are corresponding angles, corresponding sides, or neither. AC and JK
-
A student develops a spending plan for a school semester. Is this budgeting? Why?
-
Financial budgets: cash flows Monthly cash budgets of inflows and outflows are an important part of the budgeting process in most organizations. In the course of preparing a cash budget, the...
-
Consulting company: types of resources Budgeting allows an organization to identify broad resource requirements so that it can develop plans to put needed resources in place. Use an example to...
-
You are setting up a chatbot agency to service marketing, sales and customer services teams. Discuss the advantages and disadvantages of setting up the business as a sole trader or company and the...
-
Principles for Responsible Management Education (PRME) is a not-for-profit entity. It engages business schools to ensure they provide future leaders with the skills needed to balance economic and...
-
Discuss why the cash received from providing a service is revenue, yet the cash contributed by the owner is not revenue.
Study smarter with the SolutionInn App