Hello:
I'm very new to MySQL and I need to count 2 columns in the same table... and display the totals.
1) How many students are registered in a class?
Column name: `register_status` varchar (10), Values= registered, pending, Null = Yes
Count (table.registered) as Enrolled
2) How many students completed a class?
Colum name: `completion_status` varchar (10), Values= Incomplete, Complete, Null = Yes
Count (table.complete) as Finished
I tried 2 counts in the table but I get the same totals on both columns.
Any help will be greatly apreciated!
Thank you.
I'm very new to MySQL and I need to count 2 columns in the same table... and display the totals.
1) How many students are registered in a class?
Column name: `register_status` varchar (10), Values= registered, pending, Null = Yes
Count (table.registered) as Enrolled
2) How many students completed a class?
Colum name: `completion_status` varchar (10), Values= Incomplete, Complete, Null = Yes
Count (table.complete) as Finished
I tried 2 counts in the table but I get the same totals on both columns.
Any help will be greatly apreciated!
Thank you.