Simple SQL exercise

Question

Hi, i’m learning sql and i dont know ho to solve this exercise.
I have to print the total number of like the user “[e-mail]” got in his post and comment. Because “if a user get more then 300 likes in his post and comment, will became a gold user”. Thanks for the help!
This is the database:

-Users (
Username
Email PRIMARY KEY)

-Post(
Id_post PRIMARY KEY
Text
User REFERENCES Users(email))

-Comment (
Id_comment PRMARY KEY
Textcomment
User_comment REFERENCES Users(email)
Post REFERENCES Post(id_post)

-Like_post (
User_putlike REFERENCES User(email)
likep REFERENCES Post(id_post)

-Like_comment (
User_putlike REFERENCES User(email)
Likec REFERENCES Comment(id_comment)

Answer 1

select u.email from users u
join post p on p.email = u.email
join comment c on c.email = u.email
where p.email = '[e-mail]'
having count(p.email) >= 300