RevScripts Sql to add 50 point to all people above level 150

[Mohazaki]

hey guys
what sql i can make to add to all players above lvl 150 = 50 pointS?

 

[Merrok]

If you want to host a server, you should be able to do these kind of queries. Even though this might be a bit more advanced, it still counts as basic.
So for the future, I would ask you to please try and learn SQL and look on google or any other search engine how to do these kind of things.

Magical tutorial on how to fix any error

Below you will find an instruction on how to fix 99% of the issues and errors posted on this forum. Not even clickbait. And not even a video. I might have misunderstood the concept of clickbait... During all those steps, 2 important key elements should always be kept in mind: Keep calm and use...

otland.net

(Steps 3-X)
This will help you with that.

UPDATE accounts
SET accounts.points = accounts.points + 50
WHERE EXISTS(
    SELECT DISTINCT account_id FROM players
    WHERE accounts.id = players.account_id AND players.level >= 150
);

To be honest, it's not really that advanced lol.
At first I thought I'd have to use joins, then I noticed nope