Practice

 

mySQLWorkbench practice 

Query:-

----------------------------------------------------------------------------------------------------------

create Database Product

----------------------------------------------------------------------------------------------------------

create table product (

Product_ID int, Product_Name varchar(50), Product_company varchar(50), Price int, City Varchar(50)

);

----------------------------------------------------------------------------------------------------------

select * from Product;

----------------------------------------------------------------------------------------------------------

insert into product

values ("1", "Mouse", "Dell", "200", "Gurgaon");

----------------------------------------------------------------------------------------------------------

SELECT *FROM product

where not price > 200;

----------------------------------------------------------------------------------------------------------