Which SQL statement is the correct one to use to find the earliest date STORE_ID 10 had a sales amount greater than 0?
Table SALES

Question

Which SQL statement is the correct one to use to find the earliest date STORE_ID 10 had a sales amount greater than 0? 
  Table SALES

Answer

SELECT MIN(SALES_DATE) FROM SALES WHERE STORE_ID = 10 OR SALES_AMOUNT > 0;

Answer

SELECT MIN(SALES_DATE) FROM SALES WHERE STORE_ID = 10 AND SALES_AMOUNT > 0;

Answer

SELECT MAX(SALES_DATE) FROM SALES WHERE STORE_ID = 10 AND SALES_AMOUNT > 0;

Answer

SELECT SALES_DATE FROM SALES WHERE STORE_ID = 10 AND SALES_AMOUNT > 0;

Crowdly