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

Question

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

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

Explanation / Answer

Select c.code,d.countryname,count(d.isofficial) as official from country c, countrydepency d where c.code=d.countrycode and isofficial='Y' group by c.code having official>2 or d.capitalCity=null.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.