Skip to content

Instantly share code, notes, and snippets.

@ManasviniGanesh

ManasviniGanesh/alignment_jobs.sql

Created October 23, 2024 15:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ManasviniGanesh/0c71f88280889374d5094cf301bae1ea to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ManasviniGanesh/0c71f88280889374d5094cf301bae1ea to your computer and use it in GitHub Desktop.
Download ZIP
Alignment jobs processed on 18th October 2024
Raw
alignment_jobs.sql
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
FROM
DXDB.ALIGNMENT_JOB
WHERE
START_TIME > '2024-10-14'
AND END_TIME < '2024-10-17'
)
GROUP BY
ALIGNMENT_ID
ORDER BY
VJ.ALIGNMENT_ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment