1. Create the following table "WORKSHOP" with the following fields:
(NAME_OF_THE_PARTICIPANT, INSTITUTION, DESIGNATION, CITY, PARTICIPANT..JD, FEES_PAID AMOUNT, ACCOMMODATION_REQUIRED MOB_NO, EMAIL, CONTACT_ADDR1, CONTACT_ADDR2, STATE)

Select appropriate datatypes for each of the fields. Identify the primary key. Input meaningful data of at least 10 records.

2. For the above table created in Q.1, answer the following queries using SQL:

To display all the participants with designations Assistant Professors and who are from Delhi.

To display only the list of names of all the participants who require accommodation also.

To display the total amount paid by all the participants.

List all the Mob_no, Email addresses along with the names of the participants.