Question
Which SQL clause is used to filter groups after
aggregation (i.e., having aggregated value conditions)?Solution
HAVING filters groups based on aggregate functions; WHERE filters rows before grouping.
- A coin is tossed 5 times. ‘A’ wins the game if exactly 3 heads appear. Otherwise, ‘B’ wins. What is the probability that ‘A’ wins?
Two players, A and B, play a tennis match. It is known that the probability of A winning the match is 0.65. What is the probability of B winning the mat...
In a bag, there are ‘x’ pink balls and 15 white balls. If the probability of drawing a pink ball is 3/8, then calculate the probability of getting t...
The names of 10 students from section A, 12 students from section B and 14 students from section C were selected. The age of all the 36 students was dif...
In a box there are 6 red, 12 blue, and 18 yellow cards. One card is picked up randomly. What is the probability that it is neither red nor yellow?
A bag contains 3 blue, 2 green, and 5 black pens. If five pens are selected randomly, what is the probability that exactly two are green and three are b...
Two dancers Seema and Reema appeared in audition of a dance competition. The probability that seema will be selected in this dance competition is 0.05 a...
A fair coin is tossed 6 times. What is the probability of getting exactly either two or three heads?
- A 6-digit number is formed using the digits 1, 2, 3, 4, 5 and 6. If each digit can be used only once, then find the probability that the number formed will...
A bag contains 12 white and some black balls. If the probability of drawing a black ball from the bag is thrice that of drawing a white ball, fin...
