When to use RDBMS, NoSQL and NEWSqL

Hi,

Can anyone help me explain when is it best to use RBDMS, NOSQL and NewSQL? I mean the scenarios under which each one is used?

Thanks,
H