The finance team needs a report of total fees paid per student this semester. Which SQL query fits best?

Question

Computer Science · Database Management Systems

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SELECT student_id, SUM(amount) FROM fees WHERE semester=? GROUP BY student_id;

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Database Management Systems?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Database Management Systems

Mahatma Gandhi's last fast unto death in 1948 was primarily against which of the following?

What was the primary meaning of 'Swaraj' as popularized by Mahatma Gandhi during India's independence movement?

What was one major impact of India’s independence on its economy?

Answer 1

SELECT student_id, SUM(amount) FROM fees WHERE semester=? GROUP BY student_id;

Answer 2

SELECT student_id, amount FROM fees WHERE semester=? ORDER BY amount;

Answer 3

SELECT DISTINCT student_id, amount FROM fees;

Answer 4

SELECT AVG(amount) FROM fees;

Related Practice Questions