Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Note: I need help on the following questions which has two parts so please answer all of the parts and provide me with the SQL
Note: I need help on the following questions which has two parts so please answer all of the parts and provide me with the SQL entry please. I would greatly appreciate it and below I have included additional information and help that was provided with the question. Thank you!
SQL S CRIPTS FOR OTHER AGGREGATE FUNCTIONS WITH TWO TABLES J OINED: 16)Min and Max Quantity on Hand of a Product (Looking for Even and Uneven Sales) 17)PRODUCTS WITH QUANTITY ON HAND GREATHER THAN 25. SQL EC Practice: Working with Multiple Tables in 1:M Relationships Concentua1 Dacion. VENDOR (VendID, VendNam e, VendAddr) MGR (MgrID, MgrName) TYPE (Type ID, TDesc, MgrID) PRODUCT (PNum, PNam e, PPrice, PCost, TypeID, PInDate, VendID) PDETAILS ( PNum, PColor, PQtyOH) Example Data: Mar Tahle. Tune Tahle: Product Tahle: PDetails Table: SQL DDL SCRIPTS TO CREATE DB -SCRIPT TO CREATE PRACTICEEC DATABASE -OCT 21, 2019 .echo on .mode list .separator "" .output YourName_SQL_Practice_EC.txt .open Practice.db PRAGMA FOREIGN_KEYS - ON; DROP TABLE IF EXISTS PDetails; DROP TABLE IF EXISTS Product; DROP TABLE IF EXISTS Type; DROP TABLE IF EXISTS Vendor; DROP TABLE IF EXISTS Mgr; CONSTRAINT type_mgrid_fk FOREIGN KEY (MgrID) REFERENCES Mgr(MgrID)); (VendIDVendNameVendAddrCHAR(10),VARCHAR(30),VARCHAR(30), VendAddr VARCHAR(30), CONSTRAINT VendID_pk PRIMARY KEY (VendID); CREATE TABLE Product (PNumPNameCHAR(10),VARCHAR(30), .. inserting records into Product (100, 'Desk', 750, 550, O, DATE(2005-09-01'), 1221); INSERT INTO Product VALUES (150, 'Table', 600, 400, D, DATE(2005-11-01'), 3782); INSERT INTO Product VALUES (200, 'Chair', 550, 500, L, DATE(' 2006-04-01'), 4976); INSERT INTO Product VALUES (250, 'Bookcase', 220, 180, O, DATE(2006-07-01'), 4976); INSERT INTO Product VALUES (300, 'Lamp', 120, 100, O, DATE('2007-05-01'), 1221); INSERT INTO Product VALUES (350, 'Couch', 999, 500, L, DATE('2007-10-01'), 4976); INSERT INTO Product VALUES (400, 'Chair', 60, 45, D, DATE('2008-06-01'), 3782); INSERT INTO Product VALUES (450, 'Table', 200, 150, L, DATE('2008-08-01'), 5632)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started