Check out example codes for "postgresql inline table". It will help you in understanding the concepts better.

Code Example 1

join (values (1, 101), (2, 202), (3, 303), (4, 304)) as map(zone_number, output_type_id)
on ...

Learn ReactJs, React Native from akashmittal.com