Question

write a query to count active and discontinued products in sql​

Answer 1

Answer:

The COUNT() function returns the number of rows that matches a specified criteria. The AVG() function returns the average value of a numeric column. The SUM() function returns the total sum of a numeric column.

Answer 2

Answer:

it returns no of rows under specific criteria