Check your knowledge: DEVELOPERS Tests Course Materials & Test Answers | softserve.academy

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

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

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

100%

SELECT * FROM Categories WHERE CategoryID BETWEEN 4 OR 7

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

100%

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

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

100%

SELECT * FROM Categories WHERE CategoryID BETWEEN 4 AND 7

100%

View this question

Crowdly