Write a query to display unique 12th hour reading present in the electricity_reading table. Display the records sorted in descending order based on h12

To display unique 12th hour readings from the electricity_reading table and sort them in descending order based on the h12 column, you can use the following SQL query:

SELECT DISTINCT h12
FROM electricity_reading
ORDER BY h12 DESC;

Explanation:

1. SELECT DISTINCT h12: This part of the query is used to select the unique entries from the h12 column, ensuring no duplicate readings are included in the result.
2. FROM electricity_reading: This indicates that the data is being retrieved from the electricity_reading table.
3. ORDER BY h12 DESC: This clause sorts the resulting unique readings in descending order, meaning the highest readings will appear first.

This query will effectively retrieve and display the unique 12th hour readings in the specified order.