Pariniti wants to remove all the records from table Customer' with fields(Cust_ID, C_name, Amount, Dues, Address) whose dues status is 'Clear'. Select the query that will solve the purpose:
(a) Delete * Customer where dues=Clear';
(b) Remove * from Customer where dues='Clear'
(c) Drop Customer where dues='Clear';
(d) Delete from Custorner where dues='Clear';