Question

Q) write commands and queries to create and manipulate records in a table named 'Parcel' with the following fields:

a) write SQL commands to create the table given above.Set appropriate data types for the fields.

b) write a query to display details of all the parcels of Delhi

c) write a query to display details of the parcels weighing more than thousand 1000 gm

d) write a query to delete the record of the parcel with Parcel_id 109.​

Answer 1

a)

Create table Parcel(Parcel_ID int(3) Primary key, Weight int, City vαrchαr(20));

Insert into Parcel values(101, 1200, 'Delhi');

Insert into Parcel values(107, 875, 'Mumbai');

Insert into Parcel values(109, 2455, 'Pune');

Insert into Parcel values(103, 1320, 'Delhi');

Insert into Parcel values(104, 490, 'Kolkata');

b) Select * from Parcel where City = 'Delhi');

c) Select * from Parcel where Weight > 1000);

d) Delete from Parcel where Parcel_ID = 109;

Answer 2

Explanation:

please follow me please please