Question: ORACLE homework question.... Write a query that outputs the number of students in each school. Use aliases where appropriate. Sort by the number of students

ORACLE homework question....

Write a query that outputs the number of students in each school. Use aliases where appropriate. Sort by the number of students in descending order. The column headers should be SCHOOL_NAME and NUM_STUDENTS. Here is the table schema.

SYSTEM.SCHOOLS SCHOOL_ID NUMBER SCHOOL_NAME VARCHAR2 (35 BYTE) ADDRESS VARCHAR2 (60 BYTE) CITY VARCHAR2 (15 BYTE) REGION VARCHAR2 (15 BYTE) POSTAL_CODE VARCHAR2 (10 BYTE) COUNTRY VARCHAR2 (15 BYTE) PRINCIPAL_ID NUMBER > SCHOOLS_PK (SCHOOL_ID) SCHOOL_PRINCIPAL_FK (PRINCIPAL_ID) SYSTEM.PEOPLE P PERSON_ID NUMBER IF SCHOOL_ID NUMBER * FIRST_NAME VARCHAR2 (10 BYTE) LAST_NAME VARCHAR2 (20 BYTE) + * BIRTH_DATE DATE ADDRESS VARCHAR2 (60 BYTE) CITY VARCHAR2 (15 BYTE) REGION VARCHAR2 (15 BYTE) POSTAL_CODE VARCHAR2(10 BYTE) COUNTRY VARCHAR2 (15 BYTE) - PEOPLE_PK (PERSON_ID) E SYS_C0021064 (SCHOOL_ID) SYSTEM.TEACHERS P TEACHER_ID NUMBER PERSON_ID NUMBER SUBJECT_ID NUMBER +-K SALARY NUMBER TEACHERS_PK (TEACHER_ID) SYS_C0021067 (PERSON_ID) SYS_C0021068 (SUBJECT_ID) SYSTEM.SUBJECTS IP SUBJECT_ID NUMBER SUBJECT VARCHAR2 (60 BYTE) SUBJECTS_PK (SUBJECT_ID) SYSTEM.PRINCIPALS IP PRINCIPAL_ID NUMBER PERSON_ID NUMBER SALARY NUMBER -> PRINCIPALS_PK (PRINCIPAL_ID) SYS_C0021074 (PERSON_ID) SYSTEM.STUDENTS P" STUDENT_ID NUMBER PERSON_ID NUMBER GRADE_LEVEL NUMBER STUDENTS_PK (STUDENT_ID) SYS_C0021071 (PERSON_ID) KA SYSTEM.CLASSROOMS P" CLASSROOM_ID NUMBER TEACHER_ID NUMBER SUBJECT_ID NUMBER SEMESTER VARCHAR2 (6 BYTE) YEAR NUMBER (4) - CLASSROOMS_PK (CLASSROOM_ID) SYS_C0021077 (TEACHER_ID) SYS_C002 1078 (SUBJECT_ID) P SYSTEM.CLASSROOM_STUDENTS CLASSROOM_STUDENT_ID NUMBER CLASSROOM_ID NUMBER STUDENT_ID NUMBER GRADE NUMBER 839394 CLASSROOM_STUDENTS_PK (CLASSROOM_STUDENT_ID) SYS_C0021082 (STUDENT_ID) SYS_C0021081 (CLASSROOM_ID)

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!

Oracle SQL Project in Brief..... 1. There are eight tables in the schema. Write eight queries that each return one row with one column showing how many records each table has. Give the column an...

A. Write a query that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Sort the results by last name and then by first name. B....

I am using Oracle SQL Developer and only have assignments work when I use identifiers such as "emp" or "sal". I need to complete the following assignment, but all the guides I am finding use...

Can someone assist with any of these questions below: Question 1.The time required to play a certain game is uniformly distributed between 30 and 52 minutes. Complete parts a through c below. a. Find...

1 Descriptive statistics using Excel This assignment is designed to test Unit Objective 1 Due date: 10am Wednesday week 4 (21 March 2012) or as specified by your lecture This assignment is marked out...

Create and run a query that displays all employees from the employee table who have the title Senior Sales Associate. This requires that you join related tables and select columns from all them but...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

. EPU kareena Connections 2 Y 12 Com Tables (Filtered) A_EMPLOYEES ADVISOR CONTACTS COUNTRIES CUSTOMERS EMPLOYEES INVENTORIES LOCATIONS schema.sal data(1).salx 50L BTM210_L04_Talreja.sql.pdf.salx...

What is the purpose of the AS clause in SQL? It defines a search condition It assigns aliases to tables, columns, or calculations It is used in INNER JOIN to join two tables Neither of the other...

sql queries for oracle database. b) (8 points) Write the database schema for this ER diagram. c) (8 points) Write the CREATE TABLE statements for all tables identified for this database. The create...

What are the three basic financial statements, and what major information does each contain?

BBC Co is a medium-sized manufacturing company which is considering a 1 for 5 rights issue at a 15% discount to the current market price of K4.00 per share. Issue costs are expected to be K220,000...

What do you think Apple s high cash balance says about how they re planning for the future, especially with how competitive the tech world is getting?

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

How does the Job Level Table differ from the Job Family and Occupation Tables, and how are all Three tables related?

What is the Definition for Third Normal Form?

Provide two examples of a One-To-Many relationship.