Table: spanish_motor_gp_2003
Columns: rider
manufacturer
laps
time_retired
grid

Question: When the rider is Garry Mccoy and the manufacturer was Kawasaki, what was the time retired?
SQL: SELECT "time_retired" FROM spanish_motor_gp_2003 WHERE "manufacturer" = 'kawasaki' AND "rider" = 'garry mccoy'

Question: What's the highest amount of laps Garry Mccoy drove?
SQL: SELECT MAX("laps") FROM spanish_motor_gp_2003 WHERE "rider" = 'garry mccoy'

Question: If the manufacturer is Proton Kr and the grid was over 10, what was the time retired?
SQL: SELECT "time_retired" FROM spanish_motor_gp_2003 WHERE "grid" > 10 AND "manufacturer" = 'proton kr'