Table: legal_services_act_2007
Columns: regulator
rights_of_audience
conduct_of_litigation
reserved_instruments
probate_activities
notarial_activities
administration_of_oaths

Question: What is Regulator, when Conduct of Litigation is Yes, and when Probate Activities is Yes?
SQL: SELECT "regulator" FROM legal_services_act_2007 WHERE "conduct_of_litigation" = 'yes' AND "probate_activities" = 'yes'

Question: What is Reserved Instruments, when Conduct of Litigation is Yes, and when Probate Activities is No?
SQL: SELECT "reserved_instruments" FROM legal_services_act_2007 WHERE "conduct_of_litigation" = 'yes' AND "probate_activities" = 'no'

Question: What is Administration of Oaths, when Rights of Audience is Yes, and when Reserved Instruments is Yes?
SQL: SELECT "administration_of_oaths" FROM legal_services_act_2007 WHERE "rights_of_audience" = 'yes' AND "reserved_instruments" = 'yes'

Question: What is Reserved Instruments, when Conduct of Litigation is Yes, and when Probate Activities is Yes?
SQL: SELECT "reserved_instruments" FROM legal_services_act_2007 WHERE "conduct_of_litigation" = 'yes' AND "probate_activities" = 'yes'

Question: What is Probate Activities, when Reserved Instruments is No, and when Regulator is Chartered Institute of Legal Executives?
SQL: SELECT "probate_activities" FROM legal_services_act_2007 WHERE "reserved_instruments" = 'no' AND "regulator" = 'chartered institute of legal executives'

Question: What is Probate Activities, when Notarial Activities is No, when Conduct of Litigation is Yes, and when Regulator is Association of Law Costs Draftsmen?
SQL: SELECT "probate_activities" FROM legal_services_act_2007 WHERE "notarial_activities" = 'no' AND "conduct_of_litigation" = 'yes' AND "regulator" = 'association of law costs draftsmen'