Database: customers_and_orders
Question: What are the ids and product types for all products, sorted alphabetically by product name?
SQL:
SELECT product_id ,  product_type_code FROM Products ORDER BY product_name