Numeric data query examples

Sample queries for filtering motors based on different properties.

Display Motor5 object

SELECT * FROM Model WHERE BrowseName = 'Motor5'

Display motors with Acceleration of 20

SELECT * FROM Model WHERE Acceleration = 20

Display motors with Acceleration of 20 and Speed between 300 and 500

SELECT * FROM Model WHERE Acceleration > 20 AND Speed BETWEEN 30 AND 500

Display motors of Names that start with Faulty

SELECT * FROM Model WHERE BrowseName LIKE 'Faulty%'