Database Testing

CREATE TABLE:

BUGRESISTANCE TABLE

UNIVERSITY TABLE

INSERT VALUES:

INSERTING VALUES IN BUGRESISTANCE TABLE

INSERTING VALUES IN THE UNIVERSITY TABLE

BUGRESISTANCE TABLE:

UNIVERSITY TABLE:

ORDER BY CITY IN DESCENDING ORDER:

MAX INCOME INFORMATION:

INNER JOIN:

LEFT JOIN:

RIGHT JOIN:

FULL JOIN USING UNION: