Question

What will be the output of the following SQL query? SELECT COUNT(*) FROM Transactions WHERE Amount > 10000 AND Status = 'Completed';

A Returns all transaction records where amount exceeds ₹10,000
B Returns the total number of completed transactions where the amount exceeds ₹10,000
C Returns the sum of all transaction amounts greater than ₹10,000
D Returns an error because COUNT(*) cannot be used with multiple WHERE conditions
E Returns the average transaction amount for completed transactions above ₹10,000
Practice Next

Relevant for Exams:

Hey! Ask a query