CREATE TABLE table_47483 ("Company name" CLOB, "Hardware Model" CLOB, "Accreditation type" CLOB, "Accreditation level" CLOB, "Date" CLOB)

When the Nokia corporation had an accreditation level of joyn, what was the accreditation type?
SELECT "Accreditation type" FROM table_47483 WHERE "Accreditation level" = 'joyn' AND "Company name" = 'nokia corporation'
SELECT "Accreditation type" FROM "table_47483" WHERE "Accreditation level" = 'joyn' AND "Company name" = 'nokia corporation'