FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write Sqlyog queries for the following: List average salary of each job. Find average and sum of all the salaries of each job excluding clerks.

Write Sqlyog queries for the following:

  1. List average salary of each job.
  2. Find average and sum of all the salaries of each job excluding clerks.
  3. Find average and sum of the salaries of each job excluding salesmen', clerk' and 'manager'.
  4. Find count, sum and average salaries of each job excluding salesmen', clerk' and 'manager'.
  5. List average salary of each department.

Step by Step Solution

★★★★★

3.47 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

O select roletitle avgsalary from employeesabc group ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Financial Accounting Information The Alternative to Debits and Credits

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

7th Edition

978-0-538-4527, 0-538-45274-9, 978-1133161646

More Books

Students also viewed these Databases questions

Question

★★★★★
Each account has a normal balance. For the following list of accounts, indicate whether the normal balance of each is a debit or a credit. Account Normal Balance 1. Cash _____________ 2. Prepaid...

Answered: 1 week ago

Question

★★★★★
List average salary of each job. Find the average and sum of all the salaries of each job excluding clerks. Find average and sum of the salaries of each job excluding salesmen', clerk' and 'manager'....

Answered: 1 week ago

Question

★★★★★
Each account has a normal balance. For the following list of accounts, indicate whether the normal balance of each is a debit or a credit. Account 1. Cash 2. Prepaid Insurance 3. Retained Earnings 4....

Answered: 1 week ago

Question

★★★★★
Santa's Helpers Ltd estimates its income taxes at 35% of pre-tax income. For the quarter ended September 30, pre-tax income was $200,000. Prepare the journal entry to record the estimated income...

Answered: 1 week ago

Question

★★★★★
A study shows that the obesity rate among boys ages 2 to 19 has increased over the past several years. (a) Make an inference based on the results of this study. (b) What is wrong with this type of...

Answered: 1 week ago

Question

★★★★★
The function models the population of Florida, f(t), in millions, t years after 1970. a. What was Floridas population in 1970? b. According to this logistic growth model, what was Floridas...

Answered: 1 week ago

Question

★★★★★
=+b) Would you use this model? Explain.

Answered: 1 week ago

Question

★★★★★
Presented below are selected transactions of Pale Force Company. Pale Force sells in large quantities to other companies and also sells its product in a small retail outlet. March 1 Sold merchandise...

Answered: 1 week ago

Question

★★★★★
When Magdalena's outside basis is $280,000, she receives a liquidating distribution of $70,000 cash and a proportionate share of inventory having a partnership basis of $98,000 and a fair market...

Answered: 1 week ago

Question

★★★★★
Greenstone Coffee is experiencing financial pressures due to increased competition for its numerous urban coffee shops. Total sales revenue has dropped by 15% and the company wishes to establish a...

Answered: 1 week ago

Question

★★★★★
Organizational Behavior draws from other disciplines to create a unique field. Question 27Answer a. True b. False

Answered: 1 week ago

Question

★★★★★
Suppose that there are only three types of consumers and consider a one period insurance choice problem in which there is only one health plan, and it offers full insurance. Expected cost to the...

Answered: 1 week ago

Question

★★★★★
DEF Sports Shoe Company has a Distribution facility in Cambridge Ontario, that imports basketball shoes from China for distribution to retailers across Canada DEF Sports was a small entrepreneurial...

Answered: 1 week ago

Question

★★★★★
Although Toby was usually too busy to see injured athletes from the local high schools, he agreed to look at Rodney's knee injury. Rodney was the son of the county prosecutor who was a good friend of...

Answered: 1 week ago

Question

★★★★★
The Accidental Bank Robbery Case Study 1. Identify the ethical issues 2. Define possible alternatives 3. Explain the ethics of each alternative 4. What are possible constraints of each alternative?...

Answered: 1 week ago

Question

★★★★★
Design and develop an organizational learning strategy Using the feedback that you received from CEO at the meeting as well as the information you researched and evaluated for your report, create...

Answered: 1 week ago

Question

★★★★★
14 Company Alpha is expected to pay a dividend in year 1 of $2.2, a dividend in year 2 of $3.63, and a dividend in year 3 of $5. After year 3, dividends are expected to grow at the rate of 6% per...

Answered: 1 week ago

Question

★★★★★
Representative data read from a plot that appeared in the paper Effect of Cattle Treading on Erosion from Hill Pasture: Modeling Concepts and Analysis of Rainfall Simulator Data (Australian Journal...

Answered: 1 week ago

Question

★★★★★
Use of Account Balances as a Basis for Adjustments LoriMatlock operates a graphic arts business. A list of accounts on June 30, 2010, before recording any adjustments, appears as follows: Cash...

Answered: 1 week ago

Question

★★★★★
A company has a return on assets of 14% and a return on common stockholders equity of 11%. The president of the company has asked you to explain the reason for this difference. What causes the...

Answered: 1 week ago

Question

★★★★★
Glendive Corp. is in the process of preparing its statement of cash flows for the year ended June 30, 2010. An income statement for the year and comparative balance sheets are as follows: Dividends...

Answered: 1 week ago

Question

★★★★★
Cyber-Plastics, Inc., is in search of a CEO and a CFO. The company has a short list of candidates for each position. The CEO candidates graduated from Chicago (C) and three Ivy League universities:...

Answered: 1 week ago

Question

★★★★★
The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures in the financial services sector. The data file Banks contains selected information...

Answered: 1 week ago

Question

★★★★★
When A. J. Reeser signed papers to take ownership of the fitness center previously known as the Park Center Club, he realized that he had just taken the biggest financial step in his life. Every...

Answered: 1 week ago

Previous Question Next Question