mysql

Use the following information to answer question 18 to 20. Suppose there are two tables in a database for an e-commerce website. One table is called Products. The other one is called Orders. Their structures and data records are showed below: Products Table Orders Table ProdID ProdName iPhone Android Windows OrdID ProdID Quantity 1 2 4 4 19. Which statement can help us to find out which phone has never been ordered by customers? a. select Products.ProdName, Orders.Quantity from Products left outer join Orders on Products.ProdID Orders.Prod b. select Products.ProdName, Orders.Quantity from Products right outer join Orders on Products.ProdID Orders.ProdI c. select Products.ProdName, Orders.Quantity from Products inner join Orders on Products.ProdID-Orders.ProdID where Orders.Quantity is null; ID where Orders.Quantity is nul D where Orders.Quantity is null d. select Products.ProdName, Orders.Quantity from Products full inner join Orders on Products.ProdID Orders ProdID where Orders.Quantity is null; Question 20 (1 point) 20. Suppose we execute the following statement select Products.ProdName, Orders.Quantity from Products right outer join Orders on Products.ProdID Orders.ProdID; In the final report, what should we see in last ProdName cell? a. iPhone b. Android C. Windows d. null