Find the name and price of the product that has been ordered the greatest number of times.
SELECT t1.product_name ,   t1.product_price FROM products AS t1 JOIN regular_order_products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t2.product_id ORDER BY count(*) DESC LIMIT 1
name and price of the product that has been ordered the greatest number of times refers to selecting product_name and product_price from products table and joining with orders table (or a similar table tracking product orders) on product_id, then grouping by product_id, and ordering the result by count in descending order to get the top result.