If you like this video please
like share , subscribe and comment down below..
if you have any suggestion or doubt this video.
scripts:
CREATE TABLE product(
product varchar(15) NULL,
amount int NULL,
country varchar(10) NULL
)
INSERT into product VALUES ('banana', 1000, 'usa')
INSERT into product VALUES ('carrots', 1500, 'usa')
INSERT into product VALUES ('beans', 1600, 'usa')
INSERT into product VALUES ('orange', 2000, 'usa')
INSERT into product VALUES ('banana', 400, 'china')
INSERT into product VALUES ('carrots', 1200, 'china')
INSERT into product VALUES ('beans', 1500, 'china')
INSERT into product VALUES ('orange', 4000, 'china')
INSERT into product VALUES ('banana', 2000, 'canada')
INSERT into product VALUES ('carrots', 2000, 'canada')
INSERT into product VALUES ('beans', 2000, 'mexico')