Question
Consider a table Orders with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which SQL query would correctly find the total number of orders and the average TotalAmount for each CustomerID who has placed more than 5 orders? Option
- A SELECT CustomerID, COUNT(OrderI
- B SELECT CustomerID, COUNT(OrderI
- C SELECT CustomerID, COUNT(OrderI
- D , AVG(TotalAmount) FROM Orders GROUP BY CustomerID WHERE COUNT(OrderI
- D > 5; Option
- D , AVG(TotalAmount) FROM Orders WHERE COUNT(OrderI
- D > 5 GROUP BY CustomerID; Option
- D , AVG(TotalAmount) FROM Orders GROUP BY CustomerID HAVING COUNT(OrderI
- D > 5; Option
- D SELECT CustomerID, COUNT(OrderI
- D , AVG(TotalAmount) FROM Orders HAVING COUNT(OrderI
- D > 5 GROUP BY CustomerID; Option
- E None of the above
More C Programming Questions
- What is the output of the following C code? int arr[3][3] = {{1,2,3},{4,5,6},{7,8,9}}; printf("%d", *(*(arr+2)+1));
- Which of the following sorting algorithms is stable?
- In C, when an array is passed as a parameter to a function, what does sizeof(arr) typically return when evaluated inside that function?
- Consider a table Orders with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which SQL query would correctly find the total number of orders and t...
- Which C++ feature allows functions or operators to have the same name but behave differently?
- In Java, which method is called when an object is garbage collected?
- What is the output of the following C code? int a = 12, b = 10; printf("%d", a & b | a ^ b);
- What is a key difference between the malloc() and calloc() functions in C?
- In mobile computing, which type of network allows devices to connect directly to each other without using a central router or switch?
- Which of the following services is NOT commonly provided by AI/ML platforms?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)