📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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 Correct Answer Incorrect Answer
      B Returns the total number of completed transactions where the amount exceeds ₹10,000 Correct Answer Incorrect Answer
      C Returns the sum of all transaction amounts greater than ₹10,000 Correct Answer Incorrect Answer
      D Returns an error because COUNT(*) cannot be used with multiple WHERE conditions Correct Answer Incorrect Answer
      E Returns the average transaction amount for completed transactions above ₹10,000 Correct Answer Incorrect Answer

      Solution

      COUNT() counts the total number of rows satisfying all conditions in the WHERE clause. The AND operator requires BOTH conditions to be true simultaneously i.e. Amount > 10000 AND Status = 'Completed'. The result is a single integer value. Commonly used functions: • COUNT() — total rows • COUNT(column) — non-NULL values only • SUM(column) — total of numeric values • AVG(column) — arithmetic mean • MAX(column) — highest value • MIN(column) — lowest value

      Practice Next
      More SQL Questions

      Relevant for Exams:

      ask-question