Write a query to display all the details of the 'meter' whose meter_number starts with 'S' and ends with '6'.

Sure, here is a SQL query that will display all the details of the 'meter' whose meter_number starts with 'S' and ends with '6':

SELECT *
FROM meter
WHERE meter_number LIKE 'S%6';

Here is a step by step breakdown of the query:

1. SELECT *: This statement selects all columns from the table.

2. FROM meter: This statement specifies the table from which to retrieve the data, in this case, the 'meter' table.

3. WHERE meter_number LIKE 'S%6': This is a condition to filter the rows. The LIKE keyword is used in a WHERE clause to search for a specified pattern in a column. The % sign is used to define wildcards (missing letters) both before and after the pattern. Also notice that SQL is case sensitive which means 'S' and 's' are different.

So, this query will return all details of the 'meter' whose meter_number starts with 'S' and ends with '6'.