NEED SQL QUERIES FOR THIS

Consider the following relations:

Student(ssn, name, address, major)

Course(code, title)

Registered(ssn,code)

Answer this:

QUERY 1: List the codes of courses in which at least one student is registered (registered courses)

QUERY 2: List the titles of registered courses (of those in 1.)

QUERY 3: List the codes of courses for which no student is registered

QUERY 4: The titles of courses for which no student is registered.

QUERY 5: Names of students and the titles of courses they registered to.

QUERY 6: SSNs of students who are registered for Database Systems or Analysis of Algorithms.