Arithmetic operation in SQL SELECT statement

Why below query result in difficult result?
Do you always need to put number in float formation in order to use arithmetic operation in SQL SELECT statement?

SELECT (517 + 309 + 304+ 282)/6366;
=> 0

SELECT (517 + 309 + 304+ 282)/6366.0;
=>0.22180333019164

Hi @jiyeonjang7025175947,

Welcome to the Codecademy Forums.

I actually answered this exact question earlier today. Check out my answer here

2 Likes

oh Thanks a lot! am checking the answer and now it’s clear! :slight_smile: