Postgresql No data points


I start my second day with grafana. I have a problem. I put as data source a database PostgreSQL I tested the connection it works very well. My table looks like that.

My request is:
select id,count(id) from warranty group by delivery_date,id

Axes :

I have no information. I searched on the internet I do not really understand what to do. Videos on youtube do not show how they are source tables and how to create metrics with queries. Someone can point me on the right track please. Thank you

For Grafana to make sense of your data the resultset your query returns has to be structured a certain way unless you are doing a table query. Your resultset must have a column named time that represents the timestamp.

Check Time Series Queries under