Suppliers$-$Parts$-$Jobs $($SPJ$)$ Database Practice Queries

Consider the following relational database about suppliers, parts, and jobs.

Suppliers $($S$),$ parts $($P$),$ and jobs $($J$)$ are uniquely identified by supplier number $($S#$),$ part number $($P#$),$ and job number $($J#$),$ respectively. The significance of an SPJ $($shipment$)$ record is that the specified supplier supplies the specified part to the specified job in the specified quantity $($and the combination S#$,$ P#$,$ J# uniquely identifies such a record$).$ An instance of this database is given below.

$\backslash$table$[[$S# SName,Status,City$],[$S$1$ SMITH,$20,$LONDON$],[$S$2$ JONES,$10,$PARIS$],[$S$3$ BLAKE,$30,$PARIS$],[$S$4$ CLARK,$20,$LONDON$],[$S$5$ ADAMS,$30,$ATHENS$]]$

$\backslash$table$[[$S#$,$P#$,$J#$,$QTY$],[$S$1,$P$1,$J$1,200],[$S$1,$P$1,$J$4,700],[$S$2,$P$3,$J$1,400],[$S$2,$P$3,$J$2,200],[$S$2,$P$3,$J$3,200],[$S$2,$P$3,$J$4,500],[$S$2,$P$3,$J$5,600],[$S$2,$P$3,$J$6,400],[$S$2,$P$3,$J$7,800],[$S$2,$P$5,J2,100],[$S$3,$P$3,$J$1,200],[$S$3,$P$4,J2,500],[$S$4,$P$6,$J$3,300]]$ Get all supplier$-$number$/$part$-$number$/$job$-$number triples such that the indicated supplier, part, and job are not all colocated. Add the QBE view as an image, the SQL equivalent, and the actual output produced.