Question
Customers(cust_id,name): (1,'A'),(2,'B'),(3,'C'). Orders(order_id,cust_id,amount): (1,1,200),(2,2,150),(3,1,300),(4,3,100). What does the following query return? SELECT
Customers(cust_id,name): (1,'A'),(2,'B'),(3,'C'). Orders(order_id,cust_id,amount): (1,1,200),(2,2,150),(3,1,300),(4,3,100). What does the following query return? SELECT
C.name, SUM(O.amount) AS total FROM Customers C LEFT JOIN Orders O ON
C.cust_id = O.cust_id GROUP BY
C.name HAVING SUM(O.amount) > 150;
More SQL Questions
- Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
- Which of the following is a common use case for a PL/SQL trigger?
- Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
- A `BEFORE INSERT` trigger fires:
- What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
- What is the main function of a PL/SQL `TRIGGER`?
- Customers(cust_id,name): (1,'A'),(2,'B'),(3,'C'). Orders(order_id,cust_id,amount): (1,1,200),(2,2,150),(3,1,300),(4,3,100). What does the following query r...
- ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
- When does an implicit cursor get automatically declared and managed by PL/SQL?
- What is an SQL `VIEW`?
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)