How many objects can you spot in image no. 72? What objects may be identified on the same image and within the bounding box represented as (341, 27, 42, 51)?
How many objects refers to OBJ_CLASS_ID; image no. 72 refers to IMG_ID = 72; What objects refers to OBJ_CLASS; bounding box represented as (341, 27, 42, 51) refers to X = 341 and Y = 27 and W = 42 and H = 51
SELECT SUM(IIF(T1.IMG_ID = 1, 1, 0)), SUM(IIF(T1.X = 341 AND T1.Y = 27 AND T1.W = 42 AND T1.H = 51, 1, 0)) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID
database name:db_id image_and_language
ATT_CLASSES table ATT_CLASSES Cols: ATTRIBUTE CLASS ID dtype integer, ATTRIBUTE CLASS dtype text, 
OBJ_CLASSES table OBJ_CLASSES Cols: OBJECT CLASS ID dtype integer, OBJECT CLASS dtype text, 
IMG_OBJ table IMG_OBJ Cols: IMAGE ID dtype integer, OBJECT SAMPLE ID dtype integer, OBJECT CLASS ID dtype integer, X dtype integer, Y dtype integer, W dtype integer, H dtype integer, 
IMG_OBJ_ATT table IMG_OBJ_ATT Cols: IMAGE ID dtype integer, ATTRIBUTE CLASS ID dtype integer, OBJECT SAMPLE ID dtype integer, 
PRED_CLASSES table PRED_CLASSES Cols: PREDICTION CLASS ID dtype integer, PREDICTION CLASS dtype text, 
IMG_REL table IMG_REL Cols: IMAGE ID dtype integer, PREDICTION CLASS ID dtype integer, OBJECT1 SAMPLE ID dtype integer, OBJECT2 SAMPLE ID dtype integer, 
