Bissoy.com
Doctors Medicines MCQs Q&A

  1. female employees in the department.
  2. employees in the department.
  3. employees in the company.
  4. female employees in the company.
6 views

1 Answers

Option 3 : employees in the company.

Answer: Option 3

Explanation:

 (select avg(salary) from emp)

This part of the Query will get evaluated first and gives " Average Salary of all employees in the company."

select deptId, count(⋆)

from emp

where gender = "female" and salary > (select avg(salary) from emp)

group by deptId;

this will count for each department no of employees who are female and whose salary is greater than the average salary.

Lets take an example 

Empid

Name

Gender

Salary

deptid

1

A

Male

2000

CSE

2

B

Female

3000

CSE

3

C

Male

4000

CSE

4

D

Female

5000

CSE

5

E

Male

3000

ME

6

F

Female

4000

ME

7

G

Male

4000

ME

8

H

Female

2000

ME

9

I

Male

1000

CE

10

J

Female

2000

CE

11

K

Male

4000

CE

12

L

Female

5000

CE

13

M

Male

3000

EC

14

N

Female

4000

EC

15

O

Female

5000

EC

 

(select avg(salary) from emp) this will return 3400 as the average salary.

and final Query result will be

Deptid

count

CSE

1

ME

1

CE

1

EC

2
6 views

Related Questions

The following are the conditions for selecting list of a suitable candidates to be called for interview after the written test for the recruitment is conducted/ organized for management-level persons of a multi-national company. For providing accounting services and sales the candidates must (a) be holding a graduation in basic science with 65% or above or B. E degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 years as on 1/4/18 (d) have experience in an accounting firms for three years and diploma in accounting with 60% or above marks (e) be presently drawing CTC of 6 Lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred as Junior Accountant 2) at (d) & (e) above then be referred as Trainee-Accountant Satisfying all the above with experience of 5 years then be referred as senior-Accountant Satisfying all the above criteria (a-e) with CA/ ICWA / MBA (Finance) then be refereed as manager (Accounts) Read all the above information and answer the following question Shravani has passed H. SC with 72% of marks. She has done diploma in accountancy with 62% of marks. She was working with an organization in the field of accounting in the field of accounting from 4 years and was drawing CTC of 6.5 Lakhs presently. She is 28yrs as on July 2018. She may referred for the position of:?
1 Answers 5 Views
The following are the conditions for selecting list of a suitable candidates to be called for interview after the written test for the recruitment is conducted/organized for management - level persons for a multi - national company. For providing accounting services and sales the candidate must (a) be holding a graduation in basic science with 65% or above or B.E. degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 years as on 1/4/18 (d) have experience in an accounting firms for three years and diploma in accounting with 60% or above marks (e)  be presently drawing CTC of 6 Lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred as Junior Accountant 2) at (d) & (e) above then be referred as Trainee - Accountant Satisfying all the above with experience of 5 years then the referred as senior-Accountant Satisfying all the above criteria (a - e) with CA/ICWA/MBA (Finance) then be referred as manager (Accounts) Read all the above information and answer the following question Praveen has done his Masters in physics. He has no experience in accounting neither diploma. He is ready to be on training for accounting after joining. For which position he may be referred?
1 Answers 6 Views
The following are the conditions for selecting list of a suitable candidates to be called for interview after the written test for the recruitment is conducted/ organized for management-level persons of a multi-national company. For providing accounting services and sales the candidate must (a) be holding a graduation in basic science with 65% or above or B.E degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 yrs as on 1/4/18 (d) have experience in an accounting firms for three yrs and diploma in accounting with 60% or above marks (e) be presently drawing CTC of 6 Lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred as Junior Accountant 2) at (d) & (e) above then be referred as Trainee-Accountant Satisfying all the above with experience of 5 yrs then be referred as senior-Accountant Satisfying all the above criteria (a-e) with CA/ ICWA/ MBA (Finance) then be refereed as manager (Accounts) Read all the above information and answer the following question: Radha Mohan has done her graduation in physics with 58% of marks. She has passed the written examination with 76% of marks. She is 27 yrs as on June 2018. She has the experience in the accounting company for four years with salary of 7 Lakhs per annum. She also has passed diploma in accounting with 61% of marks. She may be referred for the position of:?
1 Answers 10 Views
The following are the conditions for selecting a list of suitable candidates to be called for interview after the written test for the recruitment is conducted/ organized for management-level persons for a multi-national company. For providing accounting services and sales the candidate must (a) beholding graduation in basic science with 65% or above or B.E. degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 years as on 1/4/18 (d) have experience in an accounting firm for three years and a diploma in accounting with 60% or above marks e) be presently drawing CTC 6 lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred to as Junior Accountant 2) at (d) & (e) above then be referred to as Trainee-Accountant Satisfying all the above with experience of 5 years then be referred to as senior-Accountant Satisfying all the above criteria (a-e) with CA/ICWA/MBA (Finance) then be referred to as manager (Accounts) Read all the above information and answer the following question   Praveen has done his Masters in physics. He has no experience in accounting neither diploma. He is ready to be on training for accounting after joining. For which position he may be referred.?
1 Answers 5 Views
Questions below followed by three quantities. Find the relationship between them. Quantity I: In a class with a certain number of students if a teacher weighing 78 kg is added, then average weight of class is increased by 2 kg. If one more teacher weighing 66 kg is added, then the average weight of the class increases by 3.5 kg over the original average. What is the original average weight (in kg) of the class Quantity II: The average age of 16 students and their teacher's age is 16 years. If the teacher's age is excluded, the average reduces by 2. What is the teacher's age Quantity III: Average weight of three friends A, B and C is 46 kg. Another person D joins the group and now the average is 45 kg. If another person E whose weight is 6 kg more than D, joins the group replacing A, then average weight of B, C, D and E becomes 47 kg. What is the weight of A (in kg)?
1 Answers 9 Views
The following are the criteria set by a Retail outlet for the selection of candidates for the post of Store In charge in a reputed mall. 1. The candidate must be a graduate in any stream with minimum of 50% marks. 2. The candidate must have Minimum of 5 years of Sales experience in Retail. 3. The age of the candidate should not be less than 25 years and more than 34 years as on 1st October, 2019. (a) If a candidate satisfies all the criteria except 2 as given above but has an MBA degree and has minimum of 2 years of work experience in sales, she/he must be sent to the General Manager, Recruitment for further interview. (b) If a candidate satisfies all the criteria except 3, but has more than 5 years experience as a Group Manager and above in Sales managing a team of sales executives, then she/he must be sent to the Regional Manager, Sales & Marketing, for further interview Based on the above criteria and conditions, analyze and decide which of the following course of action should be taken for the candidate whose description is provided below. Please note that you are not to assume anything other than the given information. Sujoy is a graduate with 55% marks and MBA through Correspondence. He was born on Sept 20, 1990. He has 1 year of work experience as a sales executive and 2 years of experience as a Group Manager, Sales. On the basis of the information as given above, which of the following decisions would be appropriate?
1 Answers 6 Views