Question
Given the following Relational Schema
EMP (emp_no, dept_no,emp_name,salary)
DEPT(dept_no,dept_name,location)
Write SQL query to find all the department names where the number of employees in the department is greater than 500.
Answers



  • Contributors:
More Engineering Questions..
Tell us two plus points and two negative points about Unix.
How do you determine Specific gravity of cement?
Explain the difference between rotational and irrotational flow?
what is unit power of a Turbine ?
Explain how to uninstall the libraries in Linux?
What is the unit for reluctance?
What is dhcp scope?
How do you compute the complexities of various algorithms?
What is the advantage of open source?
Define What is the tensile strength of wood?
How much water is lost through a commercial cooling tower system with a throughput of about 600 gpm?
What are the different lift augmentation devices present?
What is the withdrawal force of steel nails?
What is the average density of soil?
How can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?
What are the types of computer based social engineering attacks? explain what is phishing?
Brick strength is more or concrete block?
What is the meaning of Flaring?
Define What is aggregate?
Biomedical engineering job roles and responsibilities? Biomedical engineering job duties?


Search
Can you Answer!!
  • Q Which of these is not a song from the musical 'My Fair Lady': A Man Has Dreams; Get Me To the Church On Time; I Could Have Danced All Night; The Rain In Spain; or On the Street Where You Live?
  • Q What is "EUCALYPTUS" in cloud computing? Why is it used?
  • Q In accounting, are debit balances good?
  • Q What's the idea behind type 1 and type 2 methods of virtualization
  • Q What are the different replacement policies ?
  • Q What is display object?
  • Q Which command is valid in both bootstrap and regular mode when operating the data mover?
  • Q What are the New Job Postings from the Company or Organization, Tribunals in India ?
  • Q Which of the following is the first Bank to introduce Credit Card in India
  • Q What are the conversion methods supported by Essbase for currency applications?
  • Q How can you get a continuous with this ip on router 176.9.41.131?