Question

With a single query create a new table named QBITEM containing the ITEMNAME, AND ITEMTYPE of items in the ITEM table that have a color beginning with the letter B (e.g Brown, Black,…….) and COLOR. These columns should be called PRODUCT NAME , PRODUCT TYPE AND PRODUCT COLOR in the new table.

Answer

PRODUCT NAME	PRODUCT TYPE	PRODUCT COLOR
Map Case	E	Brown
Pocket Knife - Avon	E	Brown
Pocket Knife - Nile	E	Brown
Camel Saddle	R	Brown
Stetson	C	Black
Elephant Polo Stick	R	Bamboo

Answer 1

create table QBITEM as select ITEMNAME as PRODUCT_NAME, ITEMTYPE as PRODUCT_TYPE, COLOR as PRODUCT_COLOR from ITEM where ITEMCOLOR like 'b%'