6-10 SQL

--6.
CREATE TABLE Six
(
     name VARCHAR(255) NOT NULL,
     names VARCHAR(255) NOT NULL,
     DATE VARCHAR(255) NOT NULL,
     amount INT,
     PRIMARY KEY (amount)
)

INSERT INTO Six
VALUES ('Tim', 'Radish', '16-07-2005', 23)
INSERT INTO Six
VALUES ('Tim', 'Carrot', '18-08-2005', 28)
INSERT INTO Six
VALUES ('Tim', 'Corn', '28-08-2005', 18)

--7
CREATE TABLE seven
(
     Name VARCHAR(255) NOT NULL,
     Name2 VARCHAR(255) NOT NULL,
     needed FLOAT,
     available FLOAT,
     variance FLOAT,
     PRIMARY KEY (available)
)

INSERT INTO seven
VALUES ('Carrot', 'East', 0.82, 0.8, -0.02)
INSERT INTO seven
VALUES ('Carrot', 'West', 0.82, 0.48, -0.34)
INSERT INTO seven
VALUES ('Carrot', 'North', 0.82, 0.84, 0.02)
INSERT INTO seven
VALUES ('Carrot', 'South', 0.82, 0.66, -0.16)
--8.
CREATE TABLE eight
(
     plantfk INT NOT NULL,
     plant_date VARCHAR(255) NOT NULL,
     pick_date VARCHAR(255) NOT NULL,
     growing_days INT,
     PRIMARY KEY (growing_days)
)

INSERT INTO eight
VALUES (3, '25-04-2005', '22-08-2005', 119)
INSERT INTO eight
VALUES (4, '30-04-2005', '16-07-2005', 77)

--10
CREATE TABLE VIEW
(
     Name VARCHAR(255) NOT NULL,
     expected_weight FLOAT,
     picked_weight FLOAT,
     variance FLOAT,
     PRIMARY KEY (expected_weight)
)

INSERT INTO VIEW
VALUES ('Corn', 13.52, 12.96, -0.56)
INSERT INTO VIEW
VALUES ('Corn', 4.68, 4.58, -0.10)
INSERT INTO VIEW
VALUES ('Radish', 0.46, 0.52, 0.06)
INSERT INTO VIEW
VALUES ('Carrot', 0.96, 1.02, 0.06)
INSERT INTO VIEW
VALUES ('Carrot', 2.24, 2.32, 0.08)
INSERT INTO VIEW
VALUES ('Tomato', 2.40, 3.84, 1.44)


--9.
SELECT AVG(plantfk),Seed FROM planted GROUP
BY Seed