(Solved): Display the jobs that are located in outside London but in UK. I am struggling on this. What did I d ...

Display the jobs that are located in outside London but in UK.

I am struggling on this. What did I do wrong? What should I have done. Please make it simple to understand since I am still new at this and dont know any advanced techniques.

 

 

 

.

Select job id, job title, city, country name from jobs inner join jobs on jobs:job id = employees. job.id inner join departments on employees. department id = departments. department id inner join locations on departments.location.id = locations.location id inner join countries on locations. country id = countries. country id where country. name = 'United Kingdom' and city \( > \) 'London' and job id is not null and job title is not null \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ LOCATIONS } \\ \hline PK & LOCATION_ID \\ \hline & STREET_ADDRESS \\ & POSTAL_CODE \\ & CITY \\ & STATE_PROVINCE \\ \hline FK1 1 COUNTRY_ID \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ COUNTRIES } \\ \hline PK & COUNTRY_ID \\ \hline & COUNTRY_NAME \\ \hline FK1 & REGION_ID \\ \hline & \\ \hline & \\ \hline & \\ \hline & REGIONS \\ \hline PK & REGION_ID \\ \hline & REGION_NAME \\ \hline \end{tabular} FIRST COLUMN IS TABLE NAME, PK = PRIMARY KEY, FK = FOREIGN KEY select \( * \) from locations select * from countries Results Explain Describe Saved SQL History \begin{tabular}{lll|} \hline COUNTRY_ID & COUNTRY_NAME & REGION_ID \\ \hline AR & Argentina & 2 \\ \hline AU & Australia & 3 \\ \hline BE & Belgium & 1 \\ \hline BR & Brazil & 2 \\ \hline CA & Canada & 2 \\ \hline CH & Switzerland & 1 \\ \hline CN & China & 3 \\ \hline DE & Germany & 1 \\ \hline DK & Denmark & 1 \\ \hline EG & Egypt & 4 \\ \hline FR & France & 1 \\ \hline HK & HongKong & 3 \\ \hline IL & Israel & 4 \\ \hline IN & India & 3 \\ \hline IT & Italy & 1 \\ \hline JP & Japan & 3 \\ \hline KW & Kuwait & 4 \\ \hline MX & Mexico & 2 \\ \hline NG & Nigeria & 4 \\ \hline NL & Netherlands & 1 \\ \hline SG & Singapore & 3 \\ \hline UK & United Kingdom & 1 \\ \hline US & United States of America & 2 \\ \hline \end{tabular}