query-model.sql

SELECT price            AS predicted, 
       price_confidence AS confidence, 
       price_explain    AS info 
FROM   mindsdb.used_cars_model 
WHERE  model = "a1" 
       AND mileage = 122946 
       AND transmission = "manual" 
       AND fueltype = "petrol" 
       AND mpg = "35.4" 
       AND enginesize = 1.4 
       AND year = 2014 
       AND tax = 30;