Tell me the phones that have the word 'Provisional' in their accreditation types.
select hardware_model_name from phone where accreditation_type like 'Provisional'
How about their company names?
select company_name from phone where accreditation_type like 'Provisional';
Okay, I want to know the same information of the phones that have word 'Full' in their accreditation types.
select hardware_model_name, company_name from phone where accreditation_type like 'Full';