10 SQL Questions and Answers.

1. What is the difference between HAVING and WHERE?WHERE: is used to check conditions before the aggregation takes place. SELECT state, COUNT(city) as city_count FROM Address WHERE country = 'IN' GROUP BY state This gives you a table of all states ...