Question

Explain the following queries with example (use where clause also)
(a )select (b) update (c) insert (d) alter (e)create (f) delete

Answer 1

Warning: All the examples are codes pieces; (Did you get the pun in ";" ?)

Anyways,
Here we go hon,
(a)
Select:
This command allows you to select the required fields.

example:
select * from table where age>= 35;

(b)
Update:
It allows you to update a new value to records.

example:
Update table set color= green where fruit=apple;

(c)
Insert:
It allows you to insert different values in a row.

example:
Insert into table values (apples, red, tasty)

(d) Alter:
It allows you to create alternations on the table.
ALter table loopies add origin varchar(50);

(e) Delete:
It allows you to delete a value from a record.

Delete from Loopies where fruit=apple;