The difference between the two clauses is that having clause could be used with aggregate data while the where data couldn’t be used with the aggregate data.
Are you eager to learn SQL? Get yourself certified with SQL certification from Intellipaat which is co-created with Microsoft.
Do watch our video on SQL to get started with the training.