You asked

Sigma 23mm f 1 4 dc dn contemporary vs sony sonnar t e 24mm f 1 8 za?

Here is what the site says about that.

From Sony Sonnar T* E 24mm f/1.8 ZA: Sony Sonnar T* E 24mm f/1.8 ZA: A prime lens by Sony for APS-C cameras, 24mm f/1.8. Specs - Maker: Sony - Focal length: 24mm (prime) - Maximum aperture: f/1.8 - Made for: APS-C sensors - Mounts: Sony E - Stabilised: no - Autofocus: yes What it frames like - On APS-C (Sony E): like 36mm on full frame; f/1.8 gives about the depth of field of f/2.7 there. - On the larger-sensor bodies of Sony E: ...

From Sigma 23mm f/1.4 DC DN Contemporary: Sigma 23mm f/1.4 DC DN Contemporary: A prime lens by Sigma for APS-C cameras, 23mm f/1.4. Specs - Maker: Sigma - Focal length: 23mm (prime) - Maximum aperture: f/1.4 - Made for: APS-C sensors - Mounts: Sony E, Fujifilm X, L-Mount, Canon RF - Stabilised: no - Autofocus: yes What it frames like - On APS-C (Sony E, Fujifilm X, L-Mount): like 34mm on full frame; f/1.4 gives about the depth of field of f/2.1 there. ...

Quoted from this site's pages.

From these pages