Posted: December 3rd, 2018
just q. 1 and 2 queries
Assessment Brief
i need queries for Q.no. 1 and Q.no.2SQL queries is ./* Database Systems, 8th Ed., Rob/Coronel */
/* Type of SQL : SQL Server */
Can I Review Writer Profiles?
Yes, check anonymized profiles showcasing our writers qualifications and expertise to feel confident in your papers quality. This transparency ensures you are paired with the right expert. Profile information includes educational background and subject specializations for informed selection. Browse profiles or let us match you with the best fit. Essay writer credentials are transparently displayed for informed decision-making.
CREATE TABLE CUSTOMER (
CUS_CODE int,
CUS_LNAME varchar(15),
CUS_FNAME varchar(15),
CUS_INITIAL varchar(1),
CUS_AREACODE varchar(3),
CUS_PHONE varchar(8),
CUS_CREDITLIMIT float(8),
CUS_BALANCE float(8),
CUS_DATELSTPMT datetime,
CUS_DATELSTPUR datetime
);
INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','','0','','');
INSERT INTO CUSTOMER VALUES('10011','Dunne','Leona','K','713','894-1238','','0','','');
INSERT INTO CUSTOMER VALUES('10012','Smith','Kathy','W','615','894-2285','','345.86','','');
INSERT INTO CUSTOMER VALUES('10013','Olowski','Paul','F','615','894-2180','','536.75','','');
INSERT INTO CUSTOMER VALUES('10014','Orlando','Myron','','615','222-1672','','0','','');
INSERT INTO CUSTOMER VALUES('10015','O''Brian','Amy','B','713','442-3381','','0','','');
INSERT INTO CUSTOMER VALUES('10016','Brown','James','G','615','297-1228','','221.19','','');
INSERT INTO CUSTOMER VALUES('10017','Williams','George','','615','290-2556','','768.93','','');
INSERT INTO CUSTOMER VALUES('10018','Farriss','Anne','G','713','382-7185','','216.55','','');
INSERT INTO CUSTOMER VALUES('10019','Smith','Olette','K','615','297-3809','','0','','');
/* -- */
CREATE TABLE INVOICE (
INV_NUMBER int,
CUS_CODE int,
INV_DATE datetime,
INV_TOTAL float(8),
INV_TERMS varchar(50),
INV_STATUS varchar(50)
);
INSERT INTO INVOICE VALUES('1001','10014','3/18/2012','24.94','CASH','PAID');
INSERT INTO INVOICE VALUES('1002','10011','3/18/2012','9.98','CASH','PAID');
INSERT INTO INVOICE VALUES('1003','10012','3/18/2012','153.85','CASH','PAID');
INSERT INTO INVOICE VALUES('1004','10011','3/19/2012','34.87','CASH','PAID');
INSERT INTO INVOICE VALUES('1005','10018','3/19/2012','70.44','CASH','PAID');
INSERT INTO INVOICE VALUES('1006','10014','3/19/2012','397.83','CASH','PAID');
INSERT INTO INVOICE VALUES('1007','10015','3/19/2012','34.97','CASH','PAID');
INSERT INTO INVOICE VALUES('1008','10011','3/19/2012','399.15','CASH','PAID');
/* -- */
What If My Paper Needs Urgent Fixes?
Request free revisions within 7 days, and we will make quick adjustments to align with your feedback or professors comments. We prioritize your satisfaction with fast turnarounds. Our expedited revision service addresses urgent concerns without compromising thoroughness. Submit changes through your account for prompt results. My assignment help revision services respond rapidly to urgent modification needs.
CREATE TABLE INVTOTALS (
INV_NUMBER int,
TOTAL float(8)
);
INSERT INTO INVTOTALS VALUES('1001','24.94');
INSERT INTO INVTOTALS VALUES('1002','9.98');
INSERT INTO INVTOTALS VALUES('1003','153.85');
INSERT INTO INVTOTALS VALUES('1004','34.87');
INSERT INTO INVTOTALS VALUES('1005','70.44');
INSERT INTO INVTOTALS VALUES('1006','397.83');
INSERT INTO INVTOTALS VALUES('1007','34.97');
INSERT INTO INVTOTALS VALUES('1008','399.15');
/* -- */
CREATE TABLE LINE (
INV_NUMBER int,
LINE_NUMBER int,
P_CODE varchar(10),
LINE_UNITS float(8),
LINE_PRICE float(8)
);
INSERT INTO LINE VALUES('1001','1','13-Q2/P2','1','14.99');
INSERT INTO LINE VALUES('1001','2','23109-HB','1','9.95');
INSERT INTO LINE VALUES('1002','1','54778-2T','2','4.99');
INSERT INTO LINE VALUES('1003','1','2238/QPD','1','38.95');
INSERT INTO LINE VALUES('1003','2','1546-QQ2','1','39.95');
INSERT INTO LINE VALUES('1003','3','13-Q2/P2','5','14.99');
INSERT INTO LINE VALUES('1004','1','54778-2T','3','4.99');
INSERT INTO LINE VALUES('1004','2','23109-HB','2','9.95');
INSERT INTO LINE VALUES('1005','1','PVC23DRT','12','5.87');
INSERT INTO LINE VALUES('1006','1','SM-18277','3','6.99');
INSERT INTO LINE VALUES('1006','2','2232/QTY','1','109.92');
INSERT INTO LINE VALUES('1006','3','23109-HB','1','9.95');
INSERT INTO LINE VALUES('1006','4','89-WRE-Q','1','256.99');
INSERT INTO LINE VALUES('1007','1','13-Q2/P2','2','14.99');
INSERT INTO LINE VALUES('1007','2','54778-2T','1','4.99');
INSERT INTO LINE VALUES('1008','1','PVC23DRT','5','5.87');
INSERT INTO LINE VALUES('1008','2','WR3/TT3','3','119.95');
INSERT INTO LINE VALUES('1008','3','23109-HB','1','9.95');
/* -- */
CREATE TABLE PRODUCT (
P_CODE varchar(10),
P_DESCRIPT varchar(35),
P_INDATE datetime,
P_QTYOH int,
P_MIN int,
P_PRICE float(8),
P_DISCOUNT float(8),
V_CODE int
);
INSERT INTO PRODUCT VALUES('11QER/31','Power painter, 15 psi., 3-nozzle', '1/2/2012', '8', '5', '109.99', '0', '25595');
INSERT INTO PRODUCT VALUES('13-Q2/P2','7.25-in. pwr. saw blade', '1/12/2012', '32', '15', '14.99', '0.05', '21344');
INSERT INTO PRODUCT VALUES('14-Q1/L3','9.00-in. pwr. saw blade','2/12/2012', '18', '12', '17.49', '0', '21344');
INSERT INTO PRODUCT VALUES('1546-QQ2','Hrd. cloth, 1/4-in., 2x50', '1/14/2012', '15', '8', '39.95', '0', '23119');
INSERT INTO PRODUCT VALUES('1558-QW1','Hrd. cloth, 1/2-in., 3x50', '8/14/2011', '23', '5', '43.99', '0', '23119');
INSERT INTO PRODUCT VALUES('2232/QTY','B&D jigsaw, 12-in. blade', '2/28/2012', '8', '5', '109.92', '0.05', '24288');
INSERT INTO PRODUCT VALUES('2232/QWE','B&D jigsaw, 8-in. blade', '1/23/2012', '6', '5', '99.87', '0.05', '24288');
INSERT INTO PRODUCT VALUES('2238/QPD', 'B&D cordless drill, 1/2-in.', '12/19/2011', '12', '5', '38.95', '0.05', '25595');
INSERT INTO PRODUCT VALUES('23109-HB', 'Claw hammer', '2/19/2012', '23', '10', '9.95', '0.1', '21225');
INSERT INTO PRODUCT VALUES('23114-AA','Sledge hammer, 12 lb.','11/1/2011','8','5','14.40','0.05','');
INSERT INTO PRODUCT VALUES('54778-2T','Rat-tail file, 1/8-in. fine', '1/14/2012', '43', '20', '4.99', '0', '21344');
INSERT INTO PRODUCT VALUES('89-WRE-Q','Hicut chain saw, 16 in.', '11/6/2011', '11', '5', '256.99', '0.05', '24288');
INSERT INTO PRODUCT VALUES('PVC23DRT','PVC pipe, 3.5-in., 8-ft', '2/19/2012', '188', '75', '5.87', '0', '');
INSERT INTO PRODUCT VALUES('SM-18277','1.25-in. metal screw, 25', '2/28/2012', '172', '75', '6.99', '0', '21225');
INSERT INTO PRODUCT VALUES('SW-23116','2.5-in. wd. screw, 50', '1/23/2012', '237', '100', '8.45', '0', '21231');
INSERT INTO PRODUCT VALUES('WR3/TT3','Steel matting, 4''x8''x1/6", .5" mesh', '2/16/2012', '18', '5', '119.95', '0.1', '25595');
Can You Help with Capstone Projects?
Our writers guide you through capstone projects, delivering comprehensive research and professional presentation for your final academic milestone. We ensure every requirement is met. Capstone projects demand synthesis of all your learning into a polished, impactful deliverable. Share your guidelines for a standout result. Ace my homework culminates in excellence with our capstone project support.
/* -- */
CREATE TABLE VENDOR (
V_CODE int,
V_NAME varchar(15),
V_CONTACT varchar(50),
V_AREACODE varchar(3),
V_PHONE varchar(8),
V_STATE varchar(2),
V_ORDER varchar(1)
);
INSERT INTO VENDOR VALUES('21225','Bryson, Inc.','Smithson','615','223-3234','TN','Y');
INSERT INTO VENDOR VALUES('21226','SuperLoo, Inc.','Flushing','904','215-8995','FL','N');
INSERT INTO VENDOR VALUES('21231','D&E Supply','Singh','615','228-3245','TN','Y');
INSERT INTO VENDOR VALUES('21344','Gomez Bros.','Ortega','615','889-2546','KY','N');
INSERT INTO VENDOR VALUES('22567','Dome Supply','Smith','901','678-1419','GA','N');
INSERT INTO VENDOR VALUES('23119','Randsets Ltd.','Anderson','901','678-3998','GA','Y');
INSERT INTO VENDOR VALUES('24004','Brackman Bros.','Browning','615','228-1410','TN','N');
INSERT INTO VENDOR VALUES('24288','ORDVA, Inc.','Hakford','615','898-1234','TN','Y');
INSERT INTO VENDOR VALUES('25443','B&K, Inc.','Smith','904','227-0093','FL','N');
INSERT INTO VENDOR VALUES('25501','Damal Supplies','Smythe','615','890-3529','TN','N');
INSERT INTO VENDOR VALUES('25595','Rubicon Sis.','Orton','904','456-0092','FL','Y');
Order | Check Discount
Tags: Online Homework Help, Masters Essay Service, I need my essay completed in 300-400 words, Free Essay Samples