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
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