Question: The data for the number employed at several famous IT companies is maintained in the COMPANY table. Write a query to print the /Ds

The data for the number employed at several famous IT companies is maintained in the COMPANY table. Write a 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

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.

Step by Step Solution

★★★★★

3.41 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The attached images contain details about a database of companies with their respective employee num... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Bells company had the following transactions in the month of May. May 2. Dee Bell transferred her personal car valued at $8,000 into the business. 10. Did $4,000 of work for a customer on account....

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...

(a) A proton is released from rest and accelerates freely through a potential difference* of size 140 V. (*Note: You do not need to know the initial and final voltage values, only their difference!)...

The data for the number employed at several famous IT companies is maintained in the COMPANY table. Write a query to print the IDs of the companies that have more than 1 0 0 0 0 employees, in...

COMPANY table Write a query to print the IDs of the companies that have more than 10000 employees in ascending order of ID Input Format Name ID NAME EMPLOYEES Type Integer String Integer COMPANY...

Use Excell Functions to answer the questions. Please show formula used, along with the number that goes in cell. Open recovered workbooks? Your recent changes were saved. Do you want to continue...

(1) Which of the three company's approaches to using people analytics for talent acquisition and development is most appealing (or most concerning)? (2) Should Fukuhara turn on the most advanced part...

BETTY'S FAST FOOD, INC Need Quick One Page 1. General Company Description Financial Narrative Betty's Fast Food, Inc. (S Corp) is a small food service company incorporated in 2013 in Ohio that...

tho1978X_pt2.qxd 10/18/2000 11:26 AM Page C-1 Cases in Strategic Management tho1978X_pt2.qxd 10/18/2000 11:26 AM Page C-2 A Guide to Case Analysis I keep six honest serving men (They taught me all I...

A dough recipe calls for 3 cups of flour and 1-1/4 cups of water. You want to use the same ratio of flour to water to make a dough with 10 cups of flour. How much water should you use? a. Solve this...

The company began operations on January 1, 2019. Purchases of property, plant, and equipment during 2019 were as follows: Cost Residual Value Jan 1, 2019 Land 1 3,000,000 3,000,000 Building 1...

Which of the following best describes the concept of "earnings quality?" Multiple choice question. The level of accounting conservatism used in preparing a company's financial statements. The...

Modern Earth Company, a US Multinational enterprise has branches in Jupiter and Mar. Both branches use their own local currency unit (LCU-J) and (LCU-M), respectively. Home office sent cash and...

The three-dimensional counterpart of a triangle is a tetrahedron, which is a pyramid with four faces. We colour the four faces of such a tetrahedron blue, red, green and purple. Let B, R, G and P be...

A manufacturing business finds that on average 50 people per week (assume a 5 day work week) apply for shop-floor employment through their web-site with the company. All applications are initially...

1. Given the mission of the NYC Teaching Collaborative, why do you want to join our program and teach in high-need schools in NYC? 2. As a Partner Teacher, you will be arriving not only as a new...

A country ("Home") is populated with workers who produce either food (F) or clothing (C). There are 200 workers producing food and 100 producing clothing - these numbers are fixed. Each food worker...

Lean systems coupled with statistical process control (SPC) requires a high degree of lead to A. trust issues among workers. B. the elimination of reward systems. C. cooperation issues between...

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...

A bond with a face value of $1000 and 15 years remaining until maturity pays a coupon rate of 5%. Calculate its yield to maturity if it is priced at $900.

The downside of the long-term bond investment story occurs during periods of rising long term interest rates, when bond prices fall. During the two years preceding September 1981, the market rate of...

Two and one-half years ago the Province of Saskatchewan sold an issue of 25-year, 6% coupon bonds. Calculate an investors percent capital gain for the entire 2 -year holding period if the current...