-- create
CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  tags JSONB
);


-- insert
INSERT INTO EMPLOYEE (empId, name, tags)
VALUES 
(1, 'John Doe', '{"inoffice": {"present": 5}}'),

(2, 'Jane Smith', '{"inoffice": {"present": 15}}'),

(3, 'Bob Johnson', '{"inoffice": {"present": 20}}'),

(4, 'Alice Brown', '{"inoffice": {"present": 4}}');


-- fetch 
SELECT * 
FROM EMPLOYEE 
WHERE CAST((((EMPLOYEE.tags -> 'inoffice')) ->> 'present') AS FLOAT) < 12.0;

SELECT * 
FROM EMPLOYEE 
WHERE CAST((((EMPLOYEE.tags)) ->> 'inoffice') AS FLOAT) < 12.0;