SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Manufacturers ( Code INTEGER, Name VARCHAR(255) NOT NULL, PRIMARY KEY (Code) ); CREATE TABLE Products ( Code INTEGER, Name VARCHAR(255) NOT NULL , Price DECIMAL NOT NULL , Manufacturer INTEGER NOT NULL, PRIMARY KEY (Code), FOREIGN KEY (Manufacturer) REFERENCES Manufacturers(Code) ) ; INSERT INTO Manufacturers(Code,Name) VALUES(1,'Sony'); INSERT INTO Manufacturers(Code,Name) VALUES(2,'Creative Labs'); INSERT INTO Manufacturers(Code,Name) VALUES(3,'Hewlett-Packard'); INSERT INTO Manufacturers(Code,Name) VALUES(4,'Iomega'); INSERT INTO Manufacturers(Code,Name) VALUES(5,'Fujitsu'); INSERT INTO Manufacturers(Code,Name) VALUES(6,'Winchester'); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(1,'Hard drive',240,5); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(2,'Memory',120,6); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(3,'ZIP drive',150,4); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(4,'Floppy disk',5,6); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(5,'Monitor',240,1); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(6,'DVD drive',180,2); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(7,'CD drive',90,2); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(8,'Printer',270,3); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(9,'Toner cartridge',66,3); INSERT INTO Products(Code,Name,Price,Manufacturer) VALUES(10,'DVD burner',180,2); -- Select the names of manufacturer whose products have -- an average price larger than or equal to $150. SELECT AVG(),NAME FROM Manufacturers join Products on Manufacturers.Code=Products.Code GROUP BY Products.Price HAVING AVG(Products.Price) >= 150
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear