SELECT      order_num,     COUNT(order_num) order_lines FROM     OrderItems GROUP BY     order_num ORDER BY     order_lines;

SELECT      MAX(prod_price) max_price FROM     Products WHERE     prod_price <= 10;

SELECT      SUM(quantity) items_ordered FROM     OrderItems WHERE     prod_id = 'BR01';

SELECT      SUM(quantity) items_ordered FROM     OrderItems;

SELECT     order_num,     order_date FROM     Orders WHERE     YEAR(order_date) = 2020 AND     MONTH(order_date) = 1 ORDER BY     order_date;

SELECT      cust_id,     cust_name,     UPPER(CONCAT(SUBSTRING(cust_contact, 1, 2), SUBSTRING(cust_city, 1, 3))) user_login FROM     Customers;

SELECT      prod_id,     prod_price,     prod_price * 0.9 sale_price FROM     Products;

SELECT      vend_id,     vend_name AS vname,     vend_address AS vaddress,     vend_city AS vcity FROM     Vendors ORDER BY     vend_name;

SELECT     prod_name,     prod_desc FROM     Products WHERE     prod_desc LIKE '%toy%carrots%';

SELECT     prod_name,     prod_desc FROM     Products WHERE     prod_desc LIKE '%toy%' AND     prod_desc LIKE '%carrots%';

SELECT   prod_name,   prod_desc FROM   Products WHERE   prod_desc NOT LIKE '%toy%' ORDER BY   prod_name;

SELECT     prod_name,     prod_desc FROM     Products WHERE     prod_desc LIKE '%toy%';

SELECT     vend_name FROM     Vendors WHERE     vend_country = 'USA' AND     vend_state = 'CA' ORDER BY     vend_name;

# SELECT #     prod_name, #     prod_price # FROM #     Products # WHERE #     prod_price BETWEEN 3 AND 6 # ORDER BY #     prod_pr...