Edzy
AI TutorResourcesToolsCompareBuy
SearchDownload AppLogin
Edzy

Edzy for Classes 6-12

Edzy is a personal AI tutor for CBSE and State Board students, with curriculum-aligned guidance, practice, revision, and study plans that adapt to each learner.

  • Email: always@edzy.ai
  • Phone: +91 96256 68472
  • WhatsApp: +91 96256 68472
  • Address: Sector 63, Gurgaon, Haryana

Follow Edzy

Browse by Class

  • CBSE Class 6
  • CBSE Class 7
  • CBSE Class 8
  • CBSE Class 9
  • CBSE Class 10
  • CBSE Class 11
  • CBSE Class 12
Explore the CBSE resource hub

Explore Edzy

  • Study Resources
  • Free Study Tools
  • Best Apps for Board Exams
  • Edzy vs ChatGPT
  • About Us
  • Why We Built Edzy
  • Blog
  • CBSE AI Tutor

Support & Legal

  • Help & FAQs
  • Accessibility
  • Privacy Policy
  • Terms & Conditions
  • Refund Policy
  • Cookie Policy
  • Site Directory

© 2026 Edzy. All rights reserved.

Curriculum-aligned learning paths for students in Classes 6-12.

QS
Question Practice

What result is expected when executing: SELECT COUNT(*) FROM SALE GROUP BY PaymentMode HAVING COUNT(*) < 2?

Attempt the question, check the explanation, and continue with similar questions to build confidence before exams.

MCQ_SA
CBSE
Class 12
Informatics Practices
Informatics Practices
Querying and SQL Functions
Question Bank

What result is expected when e...

Single Answer MCQ
Q-00093880

What result is expected when executing: SELECT COUNT(*) FROM SALE GROUP BY PaymentMode HAVING COUNT(*) < 2?

1

Lists all payment modes

2

Counts transactions by payment modes only once

3

Displays payment modes with fewer than two transactions

4

Displays total counts only

Previous QuestionNext Question

Video Explanation

Answer

Solution:

Watch Video Solution

Login to get access

Keep Practising

Students who asked this also explored

Continue with nearby questions to strengthen the same chapter concept while you still have the context fresh in mind.

Q1.

What command is used to retrieve data from a database?

Single Answer MCQ
View explanation
Q2.

Which SQL function can be used to count the number of rows in a query?

Single Answer MCQ
View explanation
Q3.

To sort query results in descending order, which keyword should be used?

Single Answer MCQ
View explanation
Q4.

What type of SQL function is CONCAT()?

Single Answer MCQ
View explanation