1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
kodGreya [7K]
3 years ago
15

Suppose that we want the number of male employees in each department making more than $30,000, rather than all employees (as in

Exer- cise 7.5a). Can we specify this query in SQL? Why or why not?
Business
1 answer:
DanielleElmas [232]3 years ago
7 0

Answer:

The query may still be specified in SQL by using a nested query as follows (not all

implementations may support this type of query):

SELECT DNAME, COUNT (*)

FROM DEPARTMENT, EMPLOYEE

WHERE DNUMBER=DNO AND SEX='M' AND DNO IN ( SELECT DNO

FROM EMPLOYEE

GROUP BY DNO

HAVING AVG (SALARY) > 30000 )

GROUP BY DNAME;

Explanation:

You might be interested in
The market for gasoline has changed in a couple significant ways over the last few years: new technologies have decreased the co
Phantasy [73]
In economics, supply and demand refers to a relationship between the amount of a ware that producers wish to offer at different costs and the amount that consumers wish to purchase. 
Because of the way that automobiles are ending up more fuel proficient the general impact on the equilibrium cost of gasoline is that there will be a less need of gas required thus the cost will diminish or decrease. According to my thinking, it would be more beneficial to the economy due to the lesser degree a need however it would offer more gas because of the abatement in cost. Society utilizes different things that uses gas other than cars, for example, lawnmowers, tractors, bikes, and so on. So despite the fact that new advancements are diminishing the cost related with creating gas society still deliver items that utilizes fuel every day that will keep on having an impact on the equilibrium price overall.
4 0
3 years ago
Read 2 more answers
unlike other types of play, dramatic play is purely for fun and is not meant to be a learning experience. True or False
____ [38]

Answer:

false

Explanation:

you are always learning something

5 0
3 years ago
Three types of business​ organizations) Limited partnerships have two classes of partners. The _____ limited general partner act
tia_tia [17]

Answer:

General; limited; limited.

Explanation:

Limited partnerships have two classes of partners. These two (2) classes are;

1. General partner: it is a type of partnership in which two or more people come together and have an agreement to do business by sharing profits, assets, debts or financial and legal liabilities.

2. Limited partner: it is a type of partnership in which people come together and have an agreement to do business but the involved partners only contribute financially and solely responsible to the amount of money they invested.

Hence, the general partner actually runs the business and faces unlimited liability for the​ firm's debt, while the limited partner is only liable up to the amount the limited partner invested.

8 0
3 years ago
Which of the following statements correctly describes the effects of price​ controls? A. They cause demand disruptions and could
velikii [3]

Answer:

Option a and b

Option C                

Explanation:

A . In simple words, price control refers to the  limits on the rates that can be paid for good and services produced in a marketplace that are set up and imposed by central govt.

The purpose behind these restrictions may derive from the need to preserve the availability of products even through skills shortages, and to further delay inflation, or, instead, to help ensure a guaranteed minimum income as well for manufacturers of such products or to seek to obtain a decent living wage.

B. In simple words, due to printing of new currency the supply of money ion the  market would increase which will lead to inflation in the economy which will further lead to loss in value of the existing money in hand on the individuals.

3 0
3 years ago
Write the AddressList method newBusiness. This method searches addresses for an existing business with an identical address (i.e
max2010maxim [7]

Answer:

See explaination

Explanation:

// Address.java

public class Address {

/**

* The name of the business

*/

private String name;

/**

* The name of the street the business is on

*/

private String street;

/**

* The street number of the business

*/

private int number;

/**

* Constructs an Address that represents a business with name nm,

* at number no on the street st

*/

public Address(String nm, String st, int no)

{

name = nm;

street = st;

number = no;

}

/**

* Returns the name of the business

*/

public String getName()

{

return name;

}

/**

* Returns the name of the street on which the business is located

*/

public String getStreet()

{

return street;

}

/**

* Returns the street number of the business

*/

public int getNumber()

{

return number;

}

}

//end of Address.java

//AddressBook.java

import java.util.ArrayList;

import java.util.List;

public class AddressBook {

/**

* The list of business addresses. No two businesses in the list

* can have the same address (both the same street and street number)

*/

private List<Address> addresses;

/**

* Constructs an empty AddressBook

*/

public AddressBook()

{

addresses = new ArrayList<Address>();

}

/**

* atparam st the name of a street

* atreturn a list with the names of each business with an address on that street

*/

public List<String> onStreet(String st)

{

// create an empty output list of names of business

List<String> businessName = new ArrayList<String>();

// loop over the list of addresses

for(int i=0;i<addresses.size();i++)

{

// if ith street of address = nm, add the name of the business to the output list

if(addresses.get(i).getStreet().equalsIgnoreCase(st))

businessName.add(addresses.get(i).getName());

}

return businessName; // return the list

}

/**

* Searches for an existing business with an identical address (street and number

* both match). Updates the record to an address with name nm, street st and number no.

* If no entry already exists adds a new address to the end of the list with these parameters.

*

* atparam nm the name of the business

* atparam st the street the business is on

* atparam no the street number of the business

* atreturn the index of where the business address is on the list

*/

public int newBusiness(String nm, String st, int no)

{

// loop over the list of addresses

for(int i=0;i<addresses.size();i++)

{

// if ith index addresses match the street and number of the input st and no

if((addresses.get(i).getStreet().equalsIgnoreCase(st)) && (addresses.get(i).getNumber() == no))

{

addresses.remove(i); // remove the ith address from list

addresses.add(i, new Address(nm,st,no)); // add a new address with the input name, street and number at ith index

return i; // return the index i

}

}

// if no address match, add the business at the end of the list

addresses.add(new Address(nm,st,no));

return addresses.size()-1; // return the last index

}

}

//end of AddressBook.java

5 0
3 years ago
Other questions:
  • A TAX ON PERFUME IS AN EXAMPLE OF AN. A. INCOME TAX. B. PROPERTY TAX. C.EXCISE TAX. D.STOCK TRANSFER TAX.
    7·1 answer
  • You notice that​ Coca-Cola has a stock price of $ 40.68 and EPS of $ 2.04. Its competitor PepsiCo has EPS of $ 3.43. ​But, Jones
    12·1 answer
  • (20 points)
    13·2 answers
  • Castille Corp. purchases, for $600,000, land upon which a building and a dilapidated shed are situated. Castille plans to use th
    8·1 answer
  • Freight-in and purchase returns and allowance are not deducted from purchases to determine the net delivered cost of purchases.
    13·1 answer
  • If demand for product "A" were forecast at 1,000,000 units for the coming year and your factory has one machine capable of produ
    15·1 answer
  • Differentiate between the planning, organizing, leading, and controlling functions of management. ​
    7·1 answer
  • For which capital component must you make a tax adjustment when calculating a firmâs weighted average cost of capital (WACC)?
    7·1 answer
  • Drag each tile to the correct box.
    9·1 answer
  • When a pharmaceutical company discovers a new drug, patent law gives it market power by guaranteeing:
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!