Table: rich_comm_services
Columns: company_name
product_name
hardware_model
accreditation_type
accreditation_level
accreditation_status

Question: What is the Company Name, when the Accreditation Level is Joyn Hot Fixes, and when the Accreditation Status is Approved (Awarded 17.05.13)?
SQL: SELECT "company_name" FROM rich_comm_services WHERE "accreditation_level" = 'joyn hot fixes' AND "accreditation_status" = 'approved (awarded 17.05.13)'

Question: What is the Accreditation Type, when the Accreditation Level is Joyn, and when the Hardware Model is Nokia 700?
SQL: SELECT "accreditation_type" FROM rich_comm_services WHERE "accreditation_level" = 'joyn' AND "hardware_model" = 'nokia 700'

Question: What is the Accreditation Status, when the Product Name is LG RCS-e Client?
SQL: SELECT "accreditation_status" FROM rich_comm_services WHERE "product_name" = 'lg rcs-e client'

Question: What is the Company Name, when the Accreditation Status is Approved (Valid Until 03.07.13)?
SQL: SELECT "company_name" FROM rich_comm_services WHERE "accreditation_status" = 'approved (valid until 03.07.13)'

Question: What is the Accreditation Level, when the Hardware Model is GT-I9100?
SQL: SELECT "accreditation_level" FROM rich_comm_services WHERE "hardware_model" = 'gt-i9100'

Question: What is the Product Name, when the Company Name is HTC Corporation?
SQL: SELECT "product_name" FROM rich_comm_services WHERE "company_name" = 'htc corporation'