CREATE TABLE Manufacturers with following data types:- Code INTEGER, Name VARCHAR(255) NOT NULL, CREATE TABLE Products with following data types:- Code INTEGER, Name VARCHAR(255) NOT NULL , Price DECIMAL NOT NULL , Manufacturer INTEGER NOT NULL, INSERT following data INTO Manufacturers table :- 1,'Sony' 2,'Creative Labs' 3,'Hewlett-Packard' 4,'Iomega' 5,'Fujitsu' 6,'Winchester' INSERT following data INTO Products table 1,'Hard drive',240,5 2,'Memory',120,6 3,'ZIP drive',150,4 4,'Floppy disk',5,6 5,'Monitor',240,1 6,'DVD drive',180,2 7,'CD drive',90,2 8,'Printer',270,3 9,'Toner cartridge',66,3 10,'DVD burner',180,2 -- 1.1 Select the names of all the products in the store. -- 1.2 Select the names and the prices of all the products in the store. -- 1.3 Select the name of the products with a price less than or equal to $200. -- 1.4 Select all the products with a price between $60 and $120. -- 1.5 Select the name and price in cents (i.e., the price must be multiplied by 100). -- 1.6 Compute the average price of all the products. -- 1.7 Compute the average price of all products with manufacturer code equal to 2. -- 1.8 Compute the number of products with a price larger than or equal to $180. -- 1.9 Select the name and price of all products with a price larger than or equal to $180, and sort first by price (in descending order), and then by name (in ascending order). -- 1.10 Select all the data from the products, including all the data for each product's manufacturer. -- 1.11 Select the product name, price, and manufacturer name of all the products. -- 1.12 Select the average price of each manufacturer's products, showing only the manufacturer's code. -- 1.13 Select the average price of each manufacturer's products, showing the manufacturer's name.

CREATE TABLE Manufacturers (
 Code INTEGER,
 Name VARCHAR(255) NOT NULL
);

CREATE TABLE Products (
 Code INTEGER,
 Name VARCHAR(255) NOT NULL,
 Price DECIMAL NOT NULL,
 Manufacturer INTEGER NOT NULL
);

INSERT INTO Manufacturers VALUES
(1,'Sony'),
(2,'Creative Labs'),
(3,'Hewlett-Packard'),
(4,'Iomega'),
(5,'Fujitsu'),
(6,'Winchester');

INSERT INTO Products VALUES
(1,'Hard drive',240,5),
(2,'Memory',120,6),
(3,'ZIP drive',150,4),
(4,'Floppy disk',5,6),
(5,'Monitor',240,1),
(6,'DVD drive',180,2),
(7,'CD drive',90,2),
(8,'Printer',270,3),
(9,'Toner cartridge',66,3),
(10,'DVD burner',180,2);

-- 1.