What are the template ids with template type description "Presentation".
create table templates (template_id varchar, template_type_code varchar, PRIMARY KEY (template_id)); create table ref_template_types (template_type_code varchar, template_type_description varchar, PRIMARY KEY (template_type_code))
select t2.template_id from ref_template_types as t1 join templates as t2 on t1.template_type_code = t2.template_type_code where t1.template_type_description = "presentation"