SQL Query invalid

1

Hi all,

I’m trying to create a sensor based the information available on a MariaDB database and for that I’m trying to use the SQL integration.

The problem is that I’m always the same error message “SQL Query invalid” as displayed below:

sql
sql548×847 28 KB

What am I doing wrong?

For info, here is the info about the DB:

mariadb
mariadb1030×225 20.9 KB

Database: ELECTRICITY
Table: EV Charging
Columns available: date, kwh, cost_kwh, Received EUR Month

I’m trying to get the kwh value based on the the date field.

Can anyone help me with this?

Thank you