create ten details examples of quries from this data ... I used MySQL.. insert i
ID: 3930106 • Letter: C
Question
create ten details examples of quries from this data ... I used MySQL..
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000000, 'quarter one');
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000001, 'quarter two');
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000002, 'quarter three');
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000003, 'quarter four');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567890,'water',1111111111,'HR',0000000000,'dayton','developing','P&G');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567891,'gas',1111111112,'IT',0000000001,'vandalia','computer science','UD');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567892,'electricity',1111111113,'hiring',0000000003,'kettering','developing','GE');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567894,'water',1111111111,'HR',0000000000,'beavercreek','developing','P&G');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111111,'Michael Jordan', 'development', 'credit');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111112,'Justin George', 'internet cost', 'credit');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111113,'Carson Mary', 'investment', 'debt');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111114,'Linda Jackson', 'saving', 'debit');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111110,'John Larry', 'investment', 'credit');
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111111,1111111111,'for investment','2014',1111111111);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111112,1111111112,'for technology development','2014',1111111112);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111113,1111111113,'employee salary','2013',1111111113);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111114,1111111114,'paying last period debt','2014',1111111115);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111115,1111111115,'for investment','2013',1111111111);
insert into `MONTHDim` (`monthKey`)
value ('2013-04-05');
insert into `MONTHDim` (`monthKey`)
value ('2013-04-06');
insert into `MONTHDim` (`monthKey`)
value ('2013-06-19');
insert into `MONTHDim` (`monthKey`)
value ('2012-09-09');
insert into `MONTHDim` (`monthKey`)
value ('2014-10-12');
insert into `MONTHDim` (`monthKey`)
value ('2015-12-11');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000000,'$9000000','GE');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000001,'$150000','GMC');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000003,'$60000','UD');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000004,'$1000000000','P&G');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111111, 'maintenance','enough budget for maintenance in lobby', '2014-09-11');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111112, 'technologe development','budget for the next period', '2013-11-22');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111114, 'salary','paycheck for the parttime emloyees', '2015-01-01');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111116, 'investment','investment in stock', '2014-09-20');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111133, 'maintenance','maintenance fee for computers', '2013-09-18');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999999,'dividends','all stockholders');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999996,'catering fee','catering company');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999994,'computer hardware','comupter hardware suppliers');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999997,'payment of electricity','electricity power company');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999988,'payment of utility','utility company');
Explanation / Answer
select * from Ledger
select * from Organization
select * from Account
select * from AccountingPeriod
select * from MONTHDim
select * from BUDGET
select * from PAYMENT
select paymentKey,paymentParty where paymentDescription="payment of utility"
select budgetKey,budgetName,budgetVision where budgetKey >=1111111112
select commitmentKey,commitmentDescription where commitmentParty="GMC"
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.