Posted by: chinday February 12, 2019
Login in to Rate this Post:
0 
? 
?
Can you please help me get sql query for below output from the input provided :
OUTPUT:
TABLE:
| No of classes | Student |
| Science | A |
| Commerce | A |
| Science | B |
| Science | C |
| Commerce | C |
| Commerce | C |
| Science | B |
| Science | A |
| Science | G |
| Commerce | D |
| Commerce | D |
| No of classes | Student | Count |
| Science | A | 2 |
| Commerce | A | 1 |
| Science | B | 2 |
| Science | C | 1 |
| Commerce | C | 2 |
| Commerce | D | 2 |
| Science | G | 1 |
I will appreciate the help.