


        Please show a count of orders for all the products
        
        select ...
        
        
        I have a major issue, what if a product was never ordered?
        then the quantity will not be there
        
        I need 2 queries
        
        1) to sum/count all the ordered product
        2) to show a zero for products that were never ordered
        
        the UNION command to rescue
        
        the UNION will (by default) elimited duplicate rows
        If you want to keep duplicated code a UNION ALL
        
        I cannot code an ORDER BY in the SELECT statements, I can code
        and ORDER BY at the end, to sort the UNION merged results
        
        select name, country_code, id
        from world.city
        where population < 3000
        
        union
        
        select name, country_code, population 
        from world.city
        where district is not null
        
        order by 3

        
       
