Consider the following table Sales: | EmpID | Region | Amount | |---|---|---| | 101 | East | 5000 | | 102 | East | 3000 | | 103 | West | 7000 | | 104 | East | 2000 | | 105 | West | 4000 | | 106 | North | 3500 | Table : Sales SQL Query: SELECT Region, SUM(Amount) AS TotalSales FROM Sales WHERE Amount > 3000 GROUP BY Region HAVING SUM(Amount) > 6000; What will be the output of the query?

(C) Option figure from the original question paper

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(D) Option figure from the original question paper

Database Management Systems · Quiz 1 · 13 Jul 2025 · May 2025 term

Question 1: Consider the following table Sales: | EmpID | Region | Am…

Question 1

+4 marksOne correct option

Consider the following table Sales:

EmpID	Region	Amount
101	East	5000
102	East	3000
103	West	7000
104	East	2000
105	West	4000
106	North	3500

Table : Sales

SQL Query:

sql

1SELECT Region, SUM(Amount) AS TotalSales
2FROM Sales
3WHERE Amount > 3000
4GROUP BY Region
5HAVING SUM(Amount) > 6000;

What will be the output of the query?

Show answer

Correct answer

See the whole paper Take it as a mock test

Question 1 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 13 Jul 2025, in the May 2025 term (IIT M DIPLOMA AN EXAM QDD2 13 July 2025). It carries 4 marks.

Question 1: Consider the following table Sales: | EmpID | Region | Am…

Question 1

More questions from this paper