Consider a database $($suppliers$-$parts$-$projects$)$ with the following schema:

S $($ S#$,$ SNAME, STATUS, CITY $)$

P $(($#$,$ PNAME, COLOR, WEIGHT, CITY $)$

$J(J$#$,$ JNAME, CITY $)$

SPJ $($S#$,$ P#$,$ J#$,$ QTY$)$

Suppliers $(S),$ parts $($P$),$ and projects $($J$)$ are uniquely identified by supplier number $($S$*),$ part number $(P$#$),$ and project number $($J#$),$ respectively. Below are some sample data of the database.

$\backslash$table$[[$s$,$s#$,$SNAME,$----,--,$SPJ$,$s#$,$P#$,\frac{?}{\text{b}\text{a}\text{r}}(J$#$),$QTY$],[$STATUS$,$CITY,$],[,$s$1,$smith,$20,$London,,,$\frac{?}{\text{b}\text{a}\text{r}}(s1),\frac{?}{\text{b}\text{a}\text{r}}(P1),$J$1,200],[,$S$2,$Jones,$10,$Paris,,,s$1,$P$1,$J$4,700],[,$s$3,$Blake,$30,$Paris,,,s$2,$P$3,$J$1,400],[,$S$4,$Clark,$20,$London,,,s$2,$P$3,$J$2,200],[,$s$5,$Adams,$30,$Athens,,,s$2,$P$3,$J$3,200],[,,,,,,,$S$2,$P$3,$J$4,500],[,-,$dots,cdots,$-$cdots,,,S$2,$P$3,$J$5,600],[$P$,$P#$,$PNAME,COLOR,WEIGHT,CITY,,s$2,$P$3,$J$6,400],[,-,-$cdots,$-$cdots,,,,s$2,$P$3,$J$7,800],[,$P$1,$Nut,Red,$12,$London,,S$2,$P$5,J^2,100],[,$P$2,$Bolt,Green,$17,$Par,,s$3,$P$3,$J$1,200],[,$P$3,$Screw,Blue,$17,$Rome,,S$3,$P$4,$J$2,500],[,$P$4,$Screw,Red,$14,$London,,S$4,$P$6,$J$3,300],[,$P$5,$Cam,Blue,$12,$Paris,,S$4,$P$6,$J$7,300],[,$P$6,$cog,Red,$19,$London,,S$5,$P$2,J2,200],[,,,,,,,$S$5,$P$2,$J$4,100],[,--,--,,,,,$S$5,$P$5,$J$5,500],[$J$,$J#$,$JNAME,CITY,,,,S$5,$P$5,$J$7,100],[,--,,,-,,,$S$5,$P$6,$J$2,200],[,$J$1,$Sorter,Par:,,,,$$5,$P$1,$J$4,100],[,$J$2,$Punch,Rome,,,,S$5,$P$3,34,200],[,$J$3,$Reader,Athe,ens,,,S$5,$P$4,$J$4,800],[,$J$4,$Console,Athe,ens,,,S$5,$P$5,$J$4,400],[,$J$5,$Collator,$r$ Lonc,ion,,,S$5,$P$6,$J$4,500],[,$J$6,$Terminal,Oslc,,,,,,,$],[,37,$Tape,Lor,ion,,,,,,$]]$

Please complete the following questions with SQL SELECT statement $($The SQL statements are required in the following questions. Students can also utilize the data to test their SQL statements in their computers though the testing is optional in this assignment$).$

$(8)$ Get part numbers for parts supplied by a supplier in London to a project in London.

$(9)$ Get all pairs of city names such that a supplier in the first city supplies a project in the second city.

$(10)$ Get the total number of projects supplied by supplier S$1.$