Genomic Life interview question

What is the difference between SQL and PostgreSQL? What is "right-join" in SQL?