Sql$.$ Fixed the cod SELECTING FROM MULTIPLE TABLE

LIST ALL PM WHO ALREADY MARRIED

SELECT PM$\_$NAME,BIRTH$\_$YR$,$MAR$\_$YR FROM PRIME MINISTER,PM MARRIAGE WHERE PRIME$\_$MINISTER.PM$\_$NAME $=$ PM$\_$MARRIAGE.PM$\_$NAME

SELECT PM$\_$NAME,BIRTH$\_$YR$,$MAR$\_$YR FROM PRIME$\_$MINISTER P$,$PM MARRIAGE M WHERE P$.$PM$\_$NAME $=$ M$.$PM$\_$NAME

DISPLAY PM NAME,THEIR PARTY FOR THOSE PM WHO WAS A DEPUTY PM BUT THEY DO NOT BELONG TO THE SAME PARTY

SELECT DISTINCT PM$\_$NAME,M$.$PARTY,D$.$PARTY FROM MINISTRY M$,$ DEPUTY$\_$PM D WHERE PM$\_$NAME $=$ DEPUTY$\_$NAME AND M$.$PARTY ${?}^{{?}^{{?}^{?}}}=$ D$.$PARTY$|$

DISPLAY MINISRTY NUM,THEIR PARTY FOR THOSE WHO ARE NOT IN THE SAME PARTY AND YEAR COMMISISION AFTER OR IN $1970$

SELECT MIN$\_$NR$,$M$.$PARTY,D$.$PARTY

FROM MINISTRY M$,$ DEPUTY$\_$PM D

M$.$PARTY ${?}^{{?}^{?}}=$ D$.$PARTY

AND YR$\_$COMM $1970$;

DISPLAY DISTINCT PM NAME,TOGETHER WITH THEIR STATE REP $,$PARTY AND RECREATION FOR HAWKE RJL

SELECT DISTINCT P$.$PM$\_$NAME,P$.$STATE$\_$REP,M$.$PARTY,R$.$RECREATION FROM PRIME$\_$MINISTER P$,$ MINISRTY M$,$PM RECREATION R PM$\_$NAME $=$ 'HAWKE RJI