You asked
Is the sony a6400 good in low light?
Here is what the site says about that.
From Sony a6400: Sony a6400: A mirrorless camera by Sony with a 24.2-megapixel APS-C sensor, announced in 2019. Small and very quick to focus. There's no stabilisation in the body, so pick stabilised lenses for low light. Specs - Maker: Sony - Mount: Sony E - Sensor: APS-C, 23.5 x 15.6mm, crop factor 1.5 - Resolution: 24.2 megapixels - Stabilisation: none in the body; use stabilised lenses for slow shutter speeds - Announced: 2019 - ...
From Sony a7S III: Sony a7S III: A mirrorless camera by Sony with a 12.1-megapixel full frame sensor, announced in 2020. Built for video and low light; 12 megapixels is little for stills.
Quoted from this site's pages.