Page 66 - IP

73, "Second"

(v) SELECT AVG (Stipend) FROM EXAM WHERE DIVISION = "THIRD" ;

(vi) SELECT COUNT(DISTINCT Subject) FROM EXAM;

(vii) SELECT MIN(Average) FROM EXAM WHERE Subject = "English";

Q6 a) Write a MySQL command for creating a table "PAYMENT" whose
structure is given below:
2

Table: PAYMENT

Field Name Datatype Size Constraint

Loan_number Integer 4 Primary key

Payment_number Varchar 3

Payment_date Date

Payment_amount Integer 8 Not Null

b) In a database there are two tables "Product" and "Client" as shown below: 2

Table: PRODUCT

P_ID ProductName Manufacture Price

P001 Moisturiser XYZ 40

P002 Sanitizer LAC 35

P003 Bath Soap COP 25

P004 Shampoo TAP 95

P005 Lens Solution COP 350

Table: Client

7