how many products on the table
select count ( * ) from products
what are all the products name on this table
select product_name from products
what is the product price of red jeans
select product_price from products where product_name = "red jeans"
i want to the black jeans product price
select product_price from products where product_name = "black jeans"