Яка з конструкцій є правильною?

Question

Accepted Answer

SELECT  Product, SUM(Quantity)  AS  Product_num  
  FROM  Sumproduct  GROUP BY  Product 
 HAV IN G Product_num >1000;

Answer

SELECT  Product, SUM(Quantity)  AS  Product_num  FROM  Sumproduct  HAV IN G Product_num >1000 
 GROUP BY  Product;

Answer

SELECT  Product, SUM(Quantity)  AS  Product_num  FROM  Sumproduct  GROUP BY  Product 
 ORDER BY  2 HAV IN G Product_num >1000;

Answer

SELECT  Product, SUM(Quantity)  AS  Product_num  FROM  Sumproduct  ORDER BY  2 
 HAV IN G Product_num >1000 
 GROUP BY  Product;

Answer

SELECT  Product, SUM(Quantity)  AS  Product_num  FROM  Sumproduct  WHERE   Product  LIKE  'Skis‘ HAV IN G Product_num >1000 
 ORDER BY  2;

Crowdly