answer.
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
Morgarella [4.7K]
2 years ago
5

Which SQL command must be used when you are using a function (like SUM or COUNT) in a Select statement (like COUNT (CustomerID))

? Having Select Into Group by Order by
Computers and Technology
1 answer:
soldier1979 [14.2K]2 years ago
6 0

Answer:

Having.

Explanation:

When we are working with Select statements like COUNT(CustomerID).We should use Having clause because functions like (SUM,COUNT,AVG etc) are aggregate functions and we cannot use where clause with aggregate functions.That's why we use Having clause with aggregate functions.

for example:-

select COUNT(CustomerID),state_of_residence

from Customers

GROUP BY state_of_residence

HAVING COUNT(CustomerID)>10;

You might be interested in
Read the attached paper titled A Survey of Coarse-Grained Reconfigurable Architecture and comment on it. Make sure to specifical
Pani-rosa [81]

Answer:

lol

Explanation:

I NEED POINTS

5 0
1 year ago
The Tell Me feature also includes access to the _____ feature.
Ierofanga [76]

Answer:

the quick access toolbar can be customized to include additional commands such as. -"tell me what you want to do" box ... custom programs or additional commands that extend the functionality of a Microsoft office program ... in the open window. it also includes ribbon display options and control buttons that enable you to ...

Explanation:

7 0
2 years ago
Moore’s Law is said to be more of a trend, rather than a representation of the actual number of transistors on a silicon chip. W
inna [77]

Answer:

Moores Law is defined to be the computer law which defines that the number of transistors on the integrated circuits will double time to time such as in an interval of 2 years. Moore's Law was coined by Intel employee, Gordon Moore.Moore's law is the observation that the number of transistors in a dense integrated circuit doubles about every two years. ... Moore's law describes a driving force of technological and social change, productivity, and economic growth.

Explanation:

Moore's Law is named after Intel cofounder Gordon Moore. He observed in 1965 that transistors were shrinking so fast that every year twice as many could fit onto a chip, and in 1975 adjusted the pace to a doubling every two years. ... Intel has suggested silicon transistors can only keep shrinking for another five years.Moore's law is the observation that the number of transistors in a dense integrated circuit doubles about every two years. ... Moore's law describes a driving force of technological and social change, productivity, and economic growth.Moore's law is the observation that the number of transistors in a dense integrated circuit doubles about every two years. ... Moore's law describes a driving force of technological and social change, productivity, and economic growth. Moore's law is an observation and projection of a historical trend.Moore's law is the observation that the number of transistors in a dense integrated circuit doubles about every two years. The observation is named after Gordon Moore, the co-founder of Fairchild Semiconductor and CEO of Intel, whose 1965 paper described a doubling every year in the number of components per integrated circuit,[2] and projected this rate of growth would continue for at least another decade.[3] In 1975,[4] looking forward to the next decade,[5] he revised the forecast to doubling every two years, a compound annual growth rate (CAGR) of 40%.[6][7][8]

The doubling period is often misquoted as 18 months because of a prediction by Moore's colleague, Intel executive David House. In 1975, House noted that Moore's revised law of doubling transistor count every 2 years in turn implied that computer chip performance would roughly double every 18 months (with no increase in power consumption).[9] Moore's law is closely related to MOSFET scaling, also known as Dennard scaling,[10] as the rapid scaling and miniaturization of silicon MOSFETs (metal-oxide-semiconductor field-effect transistors, or MOS transistors)[11][12] is the key driving force behind Moore's law.[10][13]

Moore's prediction proved accurate for several decades and has been used in the semiconductor industry to guide long-term planning and to set targets for research and development (R&D).[14] Advancements in digital electronics are strongly linked to Moore's law: quality-adjusted microprocessor prices,[15] memory capacity (RAM and flash), sensors, and even the number and size of pixels in digital cameras.[16] Digital electronics has contributed to world economic growth in the late twentieth and early twenty-first centuries.[17] Moore's law describes a driving force of technological and social change, productivity, and economic growth.[18][19][20][21]

Moore's law is an observation and projection of a historical trend. It is an empirical relationship and not a physical or natural law. Although the rate held steady from 1975 until around 2012, the rate was faster during the first decade. In general, it is not logically sound to extrapolate from the historical growth rate into the indefinite future. For example, the 2010 update to the International Technology Roadmap for Semiconductors predicted that growth would slow around 2013,[22] and in 2015, Gordon Moore foresaw that the rate of progress would reach saturation: "I see Moore's law dying here in the next decade or so."[23]

Microprocessor architects report that semiconductor advancement has slowed industry-wide since around 2010, below the pace predicted by Moore's law.[24] Brian Krzanich, the former CEO of Intel, announced, "Our cadence today is closer to two and a half years than two."[25] Intel stated in 2015 that improvements in device have slowed, starting at the 22 nm feature width around 2012, and continuing at 14 nm.[26] Krzanich cited Moore's 1975 revision as a precedent for the current deceleration, which results from technical challenges and is "a natural part of the history of Moore's law".[27][28][29] Leading semiconductor manufacturers, TSMC and Samsung Electronics, have the 10 nm and 7 nm nodes in

4 0
2 years ago
Write a function named firstLast2 that takes as input an array of integers and an integer that specifies how many entries are in
frosja888 [35]

Answer:

<em>Written in C++</em>

#include<iostream>

using namespace std;

int firstLast2(int arr[], int n);

int main()

{

int n;

cout<<"Number of Elements: ";

cin>>n;  

int myarray[n];

for(int i = 0; i<n;i++) {

cin>>myarray[i];

}

firstLast2(myarray, n);

return 0;

}

int firstLast2(int arr[], int n){

if(arr[0] == 2 || arr[n - 1] == 2) {

 cout<<"True";

}

else {

cout<<"False";

}

}

Explanation:

<em>I've added the full source code as an attachment where I used comments to explain difficult lines</em>

Download cpp
4 0
2 years ago
What happens as the key length increases in an encryption application?
pashok25 [27]
<span>The answer is : Increasing the key length of DES would  protect it against brute force attacks.  </span>Brute force is when the attacker tries every key knowing that one will eventually work.  <span>Key length increase proportionally increases the key space,  having a keyspace l</span>arge enough that it takes too much time and money to accomplish a brute force attack.
6 0
2 years ago
Other questions:
  • how do you make a circuit so 1 switch will turn on/off all the lights(3 lights) and a second switch will change the lights from
    14·2 answers
  • Explain why companies design products with a planned obsolescence
    14·1 answer
  • The ratio of Chris an iood Dom's ages is
    10·1 answer
  • What is the statement describing? Agile team continuously adapt to new circumstances and enhance the methods of value delivery
    6·1 answer
  • Using the RAID controller on the motherboard, you configure three hard disks in a RAID 5 array. You leave the array unpartitione
    14·1 answer
  • Write a destructor for the CarCounter class that outputs the following. End with newline.
    9·1 answer
  • Imagine a business where there are no clear boundaries defined for data and systems ownership. As a security professional, descr
    11·1 answer
  • Seneca has just applied conditional formatting and realizes that she has made a mistake. Which action should she take to fix the
    12·2 answers
  • One tool of Lean that is a container, card, or visual limit that signals when work needs to be done or replenishment needs to be
    13·1 answer
  • Plz help code practice for python
    11·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!