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
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
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 value
Find the name and price of the product that has been ordered the greatest number of times .