How to group and sort the same column in a table https://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php
Counting the number of times a particular value appears in a column
select studentID, 15*count(*) as Fees FROM orders GROUP BY studentID;
No comments:
Post a Comment