ManasviniGanesh

SELECT
	ALIGNMENT_ID,
	MIN(VJ.ID) AS VERIFICATION_JOB_ID
FROM
	DXDB.VERIFICATION_JOB VJ
	JOIN DXDB.ALIGNMENT_JOB AL ON AL.ID = VJ.ALIGNMENT_ID
WHERE
	ALIGNMENT_ID IN (
		SELECT
			ALIGNMENT_JOB.ID