Site icon The Green Lemon

count() function cannot be divided in sqlite

I am new to SQLite. When I use MySQL, it’s reasonable to use count(*)/5. However, in SQLite, I try to calculate count(Name)/5 but the result shows zero. enter image description here

I don’t know why this won’t work. Is there any way to calculate this?

Exit mobile version