Good Morning,
I have MariaDB running on my Synology NAS and Home Assistant running on another device.
I am trying to get some information from a database into Home assistant using the SQL intergration. I believe I have the connection part sorted but its the query that I am strugging with. I am not sure where I am going wrong and would appreciate any direction.
SELECT SUM(Weight_Oz) AS 'Total Silver'
FROM metals
WHERE metal = 'Silver'
