text: CREATE TABLE Order_items (product_id VARCHAR, order_id VARCHAR); CREATE TABLE Orders (order_id VARCHAR); CREATE TABLE Products (product_name VARCHAR, product_id VARCHAR) -- Show all product names and the number of customers having an order on each product. SELECT T2.product_name, COUNT(*) FROM Order_items AS T1 JOIN Products AS T2 ON T1.product_id = T2.product_id JOIN Orders AS T3 ON T3.order_id = T1.order_id GROUP BY T2.product_name CREATE TABLE Order_items (order_id VARCHAR, product_id VARCHAR) -- Show order ids and the number of products in each order. SELECT order_id, COUNT(DISTINCT product_id) FROM Order_items GROUP BY order_id CREATE TABLE Order_items (order_id VARCHAR, product_quantity INTEGER) -- Show order ids and the total quantity in each order. SELECT order_id, SUM(product_quantity) FROM Order_items GROUP BY order_id CREATE TABLE products (product_id VARCHAR); CREATE TABLE Order_items (product_id VARCHAR) -- How many products were not included in any order? SELECT COUNT(*) FROM products WHERE NOT product_id IN (SELECT product_id FROM Order_items) CREATE TABLE Church (Open_Date INTEGER) -- How many churches opened before 1850 are there? SELECT COUNT(*) FROM Church WHERE Open_Date < 1850 CREATE TABLE Church (name VARCHAR, open_date VARCHAR, organized_by VARCHAR) -- Show the name, open date, and organizer for all churches. SELECT name, open_date, organized_by FROM Church CREATE TABLE church (name VARCHAR, open_date VARCHAR) -- List all church names in descending order of opening date. SELECT name FROM church ORDER BY open_date DESC