Database: customers_and_orders
Question: Show the id and the product type for all products, order by product name.
SQL:
SELECT product_id ,  product_type_code FROM Products ORDER BY product_name