I have table created with the following information
-- Creating Tables
create table City_Table(CityName Char(20) NOT NULL,
PopulationNo Number(5) NOT NULL,
Primary Key (CityName));
Create Table Company_Table(CompanyCode Char(20) NOT NULL,
CompanyName Char(20) NOT NULL,
CompanyLocation Char(20) NOT NULL,
Primary Key (CompanyCode),
Foreign Key (CompanyLocation) REFERENCES CITY_TABLE);
Create Table Employee_Table(EmpNo Number(5) NOT NULL,
EmpName Char(20) NOT NULL,
EmpPhone Char(20) NOT NULL,
EmpBornCity Char(20) NOT NULL,
EmpFirstSchoolCity Char(20) NOT NULL,
CompanyCode Char(20) NOT NULL,
Primary Key (EmpNo),
Foreign Key (EmpBornCity) References City_Table,
Foreign Key (EmpFirstSchoolCity) References City_Table,
Foreign Key(Companycode) References Company_Table);
and i want the following query to be exectued with following data
data is
--Insertion into City Table
Insert Into City_Table values('MELBOURNE',6000);
Insert Into City_Table values('SYDNEY',8000);
Insert Into City_Table values('PERTH',3000);
Insert Into City_Table values('GOLDCOAST',4000);
Insert Into City_Table values('QUEENSLAND',5000);
-- Insertion into Company Table
Insert Into Company_Table values('C11','INDIGIT','PERTH');
Insert Into Company_Table values('C22','LOGITECH','SYDNEY');
Insert Into Company_Table values('C33','BANNY','MELBOURNE');
Insert Into Company_Table values('C44','TECHOTECH','GOLDCOAST');
Insert Into Company_Table values('C55','INTEL','QUEENSLAND');
Insert Into Company_Table values('C66','MICROSOFT','GOLDCOAST');
-- Insertion into Employee Table
Insert Into Employee_Table values(1,'KIRAN',7122,'SYDNEY','SYDNEY','C11');
Insert Into Employee_Table values(2,'KUMAR',8822,'PERTH','SYDNEY','C22');
Insert Into Employee_Table values(3,'ANIL',9922,'MELBOURNE','MELBOURNE','C44');
Insert Into Employee_Table values(4,'NAVEEN',2224,'PERTH','MELBOURNE','C55');
Insert Into Employee_Table values(5,'KIRSH',6522,'SYDNEY','QUEENSLAND','C33');
Insert Into Employee_Table values(6,'ADAM',9522,'GOLDCOAST','GOLDCOAST','C66');
Insert Into Employee_Table values(7,'BECK',9722,'QUEENSLAND','PERTH','C11');
Insert Into Employee_Table values(8,'GAB',6524,'SYDNEY','MELBOURNE','C55');
Insert Into Employee_Table values(9,'YASHICA',8542,'PERTH','QUEENSLAND','C33');
Insert Into Employee_Table values(10,'SUE',3654,'QUEENSLAND','GOLDCOAST','C66');
Insert Into Employee_Table values(11,'JUSTIN',8547,'QUEENSLAND','SYDNEY','C11');
and the query is
--2) c. List the Company Name and the total number of all employees who work for the company.
-- Only include companies where the total number of employees is greater than or equal to 2.
-- The list must be in company name sequence.
can u please help me out in finding the solution for that please
-- Creating Tables
create table City_Table(CityName Char(20) NOT NULL,
PopulationNo Number(5) NOT NULL,
Primary Key (CityName));
Create Table Company_Table(CompanyCode Char(20) NOT NULL,
CompanyName Char(20) NOT NULL,
CompanyLocation Char(20) NOT NULL,
Primary Key (CompanyCode),
Foreign Key (CompanyLocation) REFERENCES CITY_TABLE);
Create Table Employee_Table(EmpNo Number(5) NOT NULL,
EmpName Char(20) NOT NULL,
EmpPhone Char(20) NOT NULL,
EmpBornCity Char(20) NOT NULL,
EmpFirstSchoolCity Char(20) NOT NULL,
CompanyCode Char(20) NOT NULL,
Primary Key (EmpNo),
Foreign Key (EmpBornCity) References City_Table,
Foreign Key (EmpFirstSchoolCity) References City_Table,
Foreign Key(Companycode) References Company_Table);
and i want the following query to be exectued with following data
data is
--Insertion into City Table
Insert Into City_Table values('MELBOURNE',6000);
Insert Into City_Table values('SYDNEY',8000);
Insert Into City_Table values('PERTH',3000);
Insert Into City_Table values('GOLDCOAST',4000);
Insert Into City_Table values('QUEENSLAND',5000);
-- Insertion into Company Table
Insert Into Company_Table values('C11','INDIGIT','PERTH');
Insert Into Company_Table values('C22','LOGITECH','SYDNEY');
Insert Into Company_Table values('C33','BANNY','MELBOURNE');
Insert Into Company_Table values('C44','TECHOTECH','GOLDCOAST');
Insert Into Company_Table values('C55','INTEL','QUEENSLAND');
Insert Into Company_Table values('C66','MICROSOFT','GOLDCOAST');
-- Insertion into Employee Table
Insert Into Employee_Table values(1,'KIRAN',7122,'SYDNEY','SYDNEY','C11');
Insert Into Employee_Table values(2,'KUMAR',8822,'PERTH','SYDNEY','C22');
Insert Into Employee_Table values(3,'ANIL',9922,'MELBOURNE','MELBOURNE','C44');
Insert Into Employee_Table values(4,'NAVEEN',2224,'PERTH','MELBOURNE','C55');
Insert Into Employee_Table values(5,'KIRSH',6522,'SYDNEY','QUEENSLAND','C33');
Insert Into Employee_Table values(6,'ADAM',9522,'GOLDCOAST','GOLDCOAST','C66');
Insert Into Employee_Table values(7,'BECK',9722,'QUEENSLAND','PERTH','C11');
Insert Into Employee_Table values(8,'GAB',6524,'SYDNEY','MELBOURNE','C55');
Insert Into Employee_Table values(9,'YASHICA',8542,'PERTH','QUEENSLAND','C33');
Insert Into Employee_Table values(10,'SUE',3654,'QUEENSLAND','GOLDCOAST','C66');
Insert Into Employee_Table values(11,'JUSTIN',8547,'QUEENSLAND','SYDNEY','C11');
and the query is
--2) c. List the Company Name and the total number of all employees who work for the company.
-- Only include companies where the total number of employees is greater than or equal to 2.
-- The list must be in company name sequence.
can u please help me out in finding the solution for that please