SQL : Postgresql LEFT JOIN json_agg() ignore/remove NULL

Описание

SQL : Postgresql LEFT JOIN json_agg() ignore/remove NULL
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a hidden feature that I want to share with you.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
After that, type the word 'awesome' on your keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

A brief introduction of myself,
Hey there, I am Delphi, pleased to make your acquaintance.
Let me help you get the answers you need to your questions.
SQL : Postgresql LEFT JOIN json_agg() ignore/remove NULL
I am always open to chatting or receiving comments from you if you have more specific queries.
Your input is valuable, so please comment below if you have an answer or any insights to the answer.
Your answer will be recognized and valued, and I will 'heart' it to show my appreciation.
SQL : Postgresql NULL ignore/remove JOIN LEFT json_agg()