Question: 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. 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 Edit View Navigate Run Source Team Tools Window Help sal x Lab-Assignment-1.sgl

EO oracle SQL Developer:CAU Pak-pcMDesktopWLab-Assignment-1.sql File Edit View Navigate Run Source Team Tools Window Help sal x Lab-Assignment-1.sgl Connect assignment--11 sq GGA i150277.sd Start Page SQL Worksheet History a Lab-Assignment-1 v assignment Worksheet Query Bulder assignment-11 Q10 SBLECT C. CODE AS "COUNTRY CODE COUNTRY NAME AS "COUNTRY NAME COONT KP,ISOFEICIAL) AS "No. 0F OFFICIAL LANGUAHES" ab3. FROM COUNTRY CI coUNTRYLANGUAGE F WHERE (C CODE-F.COUNTRY CODE AND F.ISOETICIAL- 'I' GROUP BY C COUNTRY CODE HAVING COUNT (P.ISOFFICIAL) 3 OR (C.CAPITAL IS NULL :l Ed Assignment Lab E-ta Tables (Fittered) et-E AQs INTERNET AGENT PRIVs E AQs INTERNET. AGENTS AOS QUEUE TABLES AQs SCHEDULES BONUS DoQuery Result x E COUNTRY a SQL l Executing: SELECTC CODE AS COUNTRY CODE ,C, COUNTRY NAME AS OOUNTR NAME COUNTOF.ISOFFICIAL)AS No. OF OFFICIALLANGUAHESTFROM COUNTRY C, COUNTRYLANGUAGE CODE COUNTRY NAMI ORA-00979: not a GROUP BY expression 00979, 000000 "not a GROUP BY expression" H CONTINENT cause: Emor at Line: 64 Column: 35 Au Reports Data Dictionary Reports OLAP Reports E- TimesTen Reports [3- User Defined Reports 2.13 PM Ask me anything

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

If you have this table exist in sql how can do question 4,5,6 i mean the code can you please write the code i need to make sure thank you in advance select from iras select from addresscity show...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Please help with this. Text below BCS 101 - Programming Concepts and Problem Solving This course will provide an introduction to programming logic and problem solving techniques using different...

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

2. Figure shows a cross-section across a diameter of a long cylindrical conductor of radius a = 2 cm carrying uniform current 170 A. What is the magnetic field at radial distances: a) 0 cm b) 1 cm c)...

1. As a manager, you are steward of the companys funds. Are you willing to forgo departmental improvements and potential salary increases to honor this claim? Remember, there is no legal obligation...

Based on the following information: State of EconomyReturn on Stock JReturn on Stock K Bear . 0 2 9 . 0 2 5 Normal . 1 2 9 . 0 5 3 Bull . 2 0 9 . 0 8 3 a . Calculate the expected return for each of...

The amount of earnest money is determined by A . the real estate agent. B . agreement of the parties. C . local real estate associations. D . state law in most jurisdictions.

3. [From your subordinates] We really think that we deserve more money for doing this job. a. Thats silly. Youre really not worth what were paying you now. b. You know that the legislature wont give...

5. [From a citizen] Can you tell me who to talk with about a junk car that Id like to have removed from the vacant lot next door? a. Thats not my department. b. Ask the secretary over there. c. That...

3. How would you advise Anita to proceed if she wants to stay in the organization and be successful? How can she increase her influence and power in the organization?