Query on Field JSON Type

-- CREATE TABLE prodi
CREATE TABLE prodi
(
  id serial NOT NULL,
  nm_prodi character varying(50),
  CONSTRAINT pk_prodi PRIMARY KEY (id)
);

-- CREATE TABLE mhs
CREATE TABLE mhs
(
  id serial NOT NULL,
  data json,
  CONSTRAINT pk_mhs PRIMARY KEY (id)
);

-- INSERT INTO TABEL prodi
INSERT INTO prodi(id, nm_prodi) VALUES(22,'Ilmu Pemerintahan');
INSERT INTO prodi(id, nm_prodi) VALUES(23,'Agroteknologi');
INSERT INTO prodi(id, nm_prodi) VALUES(24,'Ilmu Hukum');
INSERT INTO prodi(id, nm_prodi) VALUES(25,'Agribisnis');
INSERT INTO prodi(id, nm_prodi) VALUES(26,'Arsitektur');
INSERT INTO prodi(id, nm_prodi) VALUES(27,'Teknik Sipil');
INSERT INTO prodi(id, nm_prodi) VALUES(28,'Ilmu Administrasi Negara');
INSERT INTO prodi(id, nm_prodi) VALUES(29,'Pendidikan Matematika');
INSERT INTO prodi(id, nm_prodi) VALUES(30,'Manajemen');
INSERT INTO prodi(id, nm_prodi) VALUES(31,'Ekonomi Pembangunan');
INSERT INTO prodi(id, nm_prodi) VALUES(32,'Bimbingan Dan Konseling');
INSERT INTO prodi(id, nm_prodi) VALUES(33,'Kesehatan Masyarakat');
INSERT INTO prodi(id, nm_prodi) VALUES(34,'Pendidikan Pancasila Dan Kewarganegaraan');

-- INSERT INTO TABLE mhs
INSERT INTO mhs(id, data) VALUES(1,'{"nim":"001","nama":"Ridwan","id_prodi":"22"}');
INSERT INTO mhs(id, data) VALUES(2,'{"nim":"002","nama":"Roni","id_prodi":"25"}');
INSERT INTO mhs(id, data) VALUES(3,'{"nim":"003","nama":"Rustam","id_prodi":"24"}');
INSERT INTO mhs(id, data) VALUES(4,'{"nim":"004","nama":"Wirda","id_prodi":"22"}');
INSERT INTO mhs(id, data) VALUES(5,'{"nim":"005","nama":"Angel","id_prodi":"26"}');

===============================
-- SIMPLE QUERY
SELECT * FROM mhs

Result:
id | data
1  | {"nim":"001","nama":"Ridwan","id_prodi":"22"}
2  | {"nim":"002","nama":"Roni","id_prodi":"25"}
3  | {"nim":"003","nama":"Rustam","id_prodi":"24"}
4  | {"nim":"004","nama":"Wirda","id_prodi":"22"}
5  | {"nim":"005","nama":"Angel","id_prodi":"26"}


-- QUERY WITH JOIN TABLE prodi
SELECT m.data->>'nim' AS nim,m.data->>'nama' AS nama,
    pr.nm_prodi AS prodi
FROM mhs m
JOIN prodi pr ON m.data->>'id_prodi'=pr.id::text

Result:
nim | nama     | prodi
001 | Ridwan   | Ilmu Pemerintahan
004 | Wirda    | Ilmu Pemerintahan
003 | Rustam   | Ilmu Hukum
002 | Roni     | Agribisnis
005 | Angel    | Arsitektur