SQL query

Hello,

Can someone please help me in writing mysql query? I am new to SQL.
Basically, I want to retrieve the count of no of messages sent per year, where the sender is one particular person.
We have 3 tables using which I have to retrieve the data.

Please help me.

Thanks
Sandhya

Hi,
This is a MSSQL forum, although the query might be able to use in mysql (in some simple sense). Without any information of the table layout, it will be hard for anyone to help you. With the limited info, I would say you try the following:

select year, count(*) from messages where sender = 'xxx' group by year

1 Like

Thank you so much for the reply.
I have been given these information for to get the desired result.
Table layout like below (3 tables) Message, Yearlist and userlist. Please help me

Message
Table:ID
displayname
content
status

Yearlist:
Table:ID
Year:

userlist:
Table: ID
Sender:

Regards,
Sandhya

SELECT year,COUNT(1) FROM Message A INNER JOIN Yearlist B ON A.ID=B.ID INNER JOIN userlist C ON A.ID=C.ID
WHERE C.SENDER='sender name'
group by year

Thanks
Paramasivan B