The following structure of table is given on the image. Based on this structure please choose all answers which are suitable for solving next task:
display all categories when the CategoryID field is defined in interval [4..7] (end values are included)

Question

The following structure of table is given on the image. Based on this structure please choose all answers which are suitable for solving next task:

display all categories when the CategoryID field is defined in interval [4..7] (end values are included)

Table structure

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID > 4  AND  CategoryID < 7

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID > 3  AND  CategoryID < 8

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  BETWEEN  4  OR  7

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  IN  (4,5,6,7)

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  IN  [4,5,6,7]

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID >= 4  AND  CategoryID <= 7

Answer

SELECT  *  FROM  Categories  WHERE  CategoryID  BETWEEN  4  AND  7

Crowdly