Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP ME WITH THIS ORACLE SQL QUERY. I HAVE ALSO UPLOADED THE TABLES. Q-Display countries code and name which have more than 2 official

PLEASE HELP ME WITH THIS ORACLE SQL QUERY. I HAVE ALSO UPLOADED THE TABLES.

Q-Display countries code and name which have more than 2 official language Or no capital city.

[ there are total of 3 tables (city, country and countrylanguage). I have also uploaded the tables along with the query that I wrote.]

first image is query, 2nd image is of country table, 3rd image is also of country table(rest of it), 4th image is of country language table, 5th image is of city table.

Please I need a code/query that works.

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

GNP GNPOLD LOCALNAME GOVERNMENTFORM HEADOFSTATE 828 93 Nonmetropolitan Territory of The Netherlands Beatrix Islamic Emirate Mohammad orar 2 5976 (null) Afganistan/Afganestan 7984 Angola 6648 Republic Joa Eduardo doa Santos 4 63.2 null) Angui. lla Dependent Territory of the UK Ella abeth II 5 3205 2500 Shqip rie cheep Mejdani Republic 6 1630 null) Andorra Parliamentary Coprincipality 7 1941 (null) Mederlandse Antillen. Nonmetropolitan Territory of The Netherlands Beatrix Emirate Federation 8 37966 36846 Al-Imarat al-Arabiya al-Muttahida Zayid bin Sultan al-Nahayan 9 340238 323310 Argentina Federal Republic Fernando de la Rua rt Kat arjan. Republi 11 334 null) Amerika Samoa US Territory George W. Bush null null) Terres australes frangaises 14 612 584 Antigua and Barbuda Constitutional Monarchy Elisabeth II 5 351182 392911 Australia. Constitutional Monarchy Federation. Eliaabeth II 16 211860 206025 Osterreich Federal Republic s Klestil 17 4127 4100 Azarbaycan Heydar Aliyev Federal Republic Pierre Buyoya 903 982 Burundi Uburundi. Republic 9 249704 243948 Belgie/Belgique Constitutional Monarchy Federation rt 20 2357 2141 Benin. Republic Mathieu Kerkou 21 2425 2201 Burkina Faso Compaor Republic Blaise 22 32e 52 31966 Bangledesh Republic Shahabuddin Ahmed 23 12178 10169 Balgarija Republic Petar Stojanov 24 6366 6097 al-Bahrayn Monarchy (Emirate) Harad 1bn Iaa al-Khalifa 25 3527 3347 The Behanas Constitutional Monarchy Elisabeth II 26 2841 null) Bosna i Hercegovina Federal Republic Ante Jelavic CAPITAL CODE2 129 MW 1 AF 56 A0 62 AI 34 AL 55 AD 33 AN 65 AE 69 AR 126 AM 54 AS null) AQ null) TF 63 AG 135 AU 1523 AT 144 552 BI 179 BE 187 BJ 549 BF 150 BD 539 BG 149 BH 148 BS 201 BA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Building Database Driven Catalogs

Authors: Sherif Danish

1st Edition

0070153078, 978-0070153073

More Books

Students also viewed these Databases questions