Question

Match List-I with List-II:

List-I	List-II
(A) group by	(III) having
(B) mid()	(IV) text function
(C) count()	(II) aggregate function
(D) mod()	(I) math function

• A. (A)-(III), (B)-(IV), (C)-(II), (D)-(I)
• B. (A)-(I), (B)-(III), (C)-(II), (D)-(IV)
• C. (A)-(II), (B)-(IV), (C)-(I), (D)-(III)
• D. (A)-(III), (B)-(IV), (C)-(II), (D)-(I)

Hint:

Remember: \textbf{Aggregate functions} summarize data (COUNT, SUM), \textbf{text functions} work on strings (MID), and \textbf{math functions} handle numbers (MOD).

Answer 1

The Correct Option is A

Step 1: Recall functions.
- group by: Used with having clause to group rows → (III).
- mid(): A string function that extracts a substring → (IV) text function.
- count(): An aggregate function used to count rows/values → (II).
- mod(): A mathematical function that returns the remainder → (I).

Step 2: Match correctly.
(A) - (III), (B) - (IV), (C) - (II), (D) - (I).
Final Answer: \[ \boxed{(A)-(III), (B)-(IV), (C)-(II), (D)-(I)} \]