SQL - query regarding count

Q&A
#1

Question - Can I use Select count(id)/count(distinct(id) from transaction ? Can I use two counts like stated? If not, why?

Data:

1  200
2  300
1  150
3  350
2  250
#2

What’s up, Mate?

The query you provided wouldn’t run, you have unbalanced parentheses.

If you were to fix this, then the query would run and the result would be a table with the single value of 2 (or 2.0 depending on the SQL flavor).