Random Computer Science Practice

Assume that you are working for ABC Corporation (ABCC). ABCC allots contracts to different contractors for some of its works. The data of Contracts and Contractors are kept in the tables

and respectively. Following are a few records from these two tables of ABCC's database.

Note: The tables contain many more records than shown here. As an employee of ABCC, you are required to write the SQL queries for the following: (I) To display all the records from the Work table in alphabetical order of W_Name. (II) To display the names of contractors where W_Amt is more than 15000. (III) To display the structure of Work table. (IV) To delete the records of contractors whose phone number is not known.