Hello everyone. I have tried to figure this SQL query out for a while but couldn't get it to work. Basically, I have the following data from vehicle 5OEC140 w/ 2 columns

Tire_Position
LF
LF
RF
RR

Tire_number
1
2
3
4

I tried to write an SQL query that would add the total of tire_number. So the answer would be 10, but all I got is 4. Here's my query

Select Count(Tire_Number) Total
From Tire
Where License_Number = '5OEC140';

Please advise what I did wrong. Thanks a lot guys. Ryan