If we want to count the number of distinct product and year combinations with a price greater than 400, we can use the following SQL query: SELECT COUNT(DISTINCT (prod, year)) This will return the result 2, as there are two distinct products (Pro1 and Pro2) sold in the year 2018 with a price greater than 300.

To count the number of distinct products sold in the year 2018 with a price greater than 300, we can use the following SQL query: SELECT COUNT(DISTINCT prod)įROM product_mast WHERE year = 2018 AND price > 300 This will return the result 4, as there are four distinct product and year combinations (Pro1-2018, Pro2-2019, Pro2-2018, and Pro3-2019) in the product_mast table. If we want to count the number of distinct product and year combinations, we can use the following SQL query: SELECT COUNT(DISTINCT (prod, year)) This will return the result 2, as there are two distinct products (Pro1 and Pro2) sold in the year 2018. To count the number of distinct products sold in the year 2018, we can use the following SQL query: SELECT COUNT(DISTINCT prod)

Toad for oracle download