Examples

SELECT SUM(o_totalprice) AS sum_of_totalprice,

       COUNT(o_totalprice) AS total_number_of_purches,

       AVG(o_totalprice) AS avg_price,

       STDDEV(o_totalprice) AS stddev_from_avg,

       MIN(o_date) AS the_minimum_date,

       MAX(o_date) AS the_maximum_date,

       o_name

FROM orders

GROUP BY o_name

ORDER BY sum_of_totalprice;

SELECT * FROM orders

WHERE o_totalprice = (SELECT MAX(o_totalprice)

                      FROM orders

                     );

SELECT

  SUM((sale_price - purchse_price) * number_of_sold_items) AS total_profit

FROM transactions;

SELECT COUNT( DISTINCT c_name) as customers FROM customers;

SELECT COUNT(DISTINCT purchse_price+sale_price) FROM transactions;