Question

Write suitable SQL query for the following:

To display the last three characters of the registration_number column (attribute) in the Vehicles table. (Note: The registration numbers are stored in the format DL-01-AV-1234).

Answer 1

SELECT RIGHT(registration_number, 3) FROM Vehicles;