📊 GMAT Exam Prep

Given a table tracking vehicle maintenance records (Vehicle ID, Last Service Date, Odometer Reading, Service Type, Next Service Due), which query would identify all vehicles that are overdue for an 'Oil Change' service based on a 6-month interval from the Last Service Date?

A Filter by 'Service Type' = 'Oil Change' AND 'Last Service Date' is more than 6 months ago.
B Filter by 'Next Service Due' is in the past.
C Sort by 'Odometer Reading' in descending order and select the top 10.
D Group by 'Vehicle ID' and count the number of 'Service Type' = 'Oil Change' entries.

✓ Correct Answer: Option A

To find overdue oil changes, you need to filter for 'Oil Change' service type and then check if the 'Last Service Date' for those entries is older than 6 months from the current date.

Related GMAT Exam Prep Questions