baking=> \d List of relations Schema | Name | Type | Owner --------+--------------+-------+--------- public | bakers | table | kkuzmin public | episodes | table | kkuzmin public | favorites | table | kkuzmin public | results | table | kkuzmin public | showstoppers | table | kkuzmin public | signatures | table | kkuzmin public | technicals | table | kkuzmin (7 rows) baking=> \d+ bakers Table "public.bakers" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ------------+------------------------+-----------+----------+---------+----------+--------------+------------- baker | character varying(10) | | not null | | extended | | fullname | character varying(100) | | | | extended | | age | integer | | | | plain | | occupation | character varying(100) | | | | extended | | hometown | character varying(100) | | | | extended | | Indexes: "bakers_pkey" PRIMARY KEY, btree (baker) Referenced by: TABLE "favorites" CONSTRAINT "favorites_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "results" CONSTRAINT "results_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "showstoppers" CONSTRAINT "showstoppers_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "signatures" CONSTRAINT "signatures_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "technicals" CONSTRAINT "technicals_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) Access method: heap baking=> SELECT baking-> * baking-> FROM baking-> bakers a baking-> , bakers b ; baker | fullname | age | occupation | hometown | baker | fullname | age | occupation | hometown ---------+---------------------+-----+-----------------------------------+---------------+---------+---------------------+-----+-----------------------------------+--------------- Antony | Antony Amourdoux | 30 | Banker | London | Antony | Antony Amourdoux | 30 | Banker | London Antony | Antony Amourdoux | 30 | Banker | London | Briony | Briony Williams | 33 | Full-time parent | Bristol Antony | Antony Amourdoux | 30 | Banker | London | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Antony | Antony Amourdoux | 30 | Banker | London | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Antony | Antony Amourdoux | 30 | Banker | London | Jon | Jon Jenkins | 47 | Blood courier | Newport Antony | Antony Amourdoux | 30 | Banker | London | Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield Antony | Antony Amourdoux | 30 | Banker | London | Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds Antony | Antony Amourdoux | 30 | Banker | London | Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield Antony | Antony Amourdoux | 30 | Banker | London | Manon | Manon Lagrève | 26 | Software project manager | London Antony | Antony Amourdoux | 30 | Banker | London | Rahul | Rahul Mandal | 30 | Research scientist | Rotherham Antony | Antony Amourdoux | 30 | Banker | London | Ruby | Ruby Bhogal | 29 | Project manager | London Antony | Antony Amourdoux | 30 | Banker | London | Terry | Terry Hartill | 56 | Retired air steward | West Midlands Briony | Briony Williams | 33 | Full-time parent | Bristol | Antony | Antony Amourdoux | 30 | Banker | London Briony | Briony Williams | 33 | Full-time parent | Bristol | Briony | Briony Williams | 33 | Full-time parent | Bristol Briony | Briony Williams | 33 | Full-time parent | Bristol | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Briony | Briony Williams | 33 | Full-time parent | Bristol | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Briony | Briony Williams | 33 | Full-time parent | Bristol | Jon | Jon Jenkins | 47 | Blood courier | Newport Briony | Briony Williams | 33 | Full-time parent | Bristol | Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield Briony | Briony Williams | 33 | Full-time parent | Bristol | Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds Briony | Briony Williams | 33 | Full-time parent | Bristol | Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield Briony | Briony Williams | 33 | Full-time parent | Bristol | Manon | Manon Lagrève | 26 | Software project manager | London Briony | Briony Williams | 33 | Full-time parent | Bristol | Rahul | Rahul Mandal | 30 | Research scientist | Rotherham Briony | Briony Williams | 33 | Full-time parent | Bristol | Ruby | Ruby Bhogal | 29 | Project manager | London Briony | Briony Williams | 33 | Full-time parent | Bristol | Terry | Terry Hartill | 56 | Retired air steward | West Midlands Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Antony | Antony Amourdoux | 30 | Banker | London Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Briony | Briony Williams | 33 | Full-time parent | Bristol Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Jon | Jon Jenkins | 47 | Blood courier | Newport Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Manon | Manon Lagrève | 26 | Software project manager | London Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Rahul | Rahul Mandal | 30 | Research scientist | Rotherham Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Ruby | Ruby Bhogal | 29 | Project manager | London Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Terry | Terry Hartill | 56 | Retired air steward | West Midlands Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Antony | Antony Amourdoux | 30 | Banker | London Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Briony | Briony Williams | 33 | Full-time parent | Bristol Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Jon | Jon Jenkins | 47 | Blood courier | Newport Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Manon | Manon Lagrève | 26 | Software project manager | London Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Rahul | Rahul Mandal | 30 | Research scientist | Rotherham Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Ruby | Ruby Bhogal | 29 | Project manager | London Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Terry | Terry Hartill | 56 | Retired air steward | West Midlands Jon | Jon Jenkins | 47 | Blood courier | Newport | Antony | Antony Amourdoux | 30 | Banker | London Jon | Jon Jenkins | 47 | Blood courier | Newport | Briony | Briony Williams | 33 | Full-time parent | Bristol Jon | Jon Jenkins | 47 | Blood courier | Newport | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Jon | Jon Jenkins | 47 | Blood courier | Newport | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Jon | Jon Jenkins | 47 | Blood courier | Newport | Jon | Jon Jenkins | 47 | Blood courier | Newport Jon | Jon Jenkins | 47 | Blood courier | Newport | Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield Jon | Jon Jenkins | 47 | Blood courier | Newport | Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds Jon | Jon Jenkins | 47 | Blood courier | Newport | Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield Jon | Jon Jenkins | 47 | Blood courier | Newport | Manon | Manon Lagrève | 26 | Software project manager | London Jon | Jon Jenkins | 47 | Blood courier | Newport | Rahul | Rahul Mandal | 30 | Research scientist | Rotherham Jon | Jon Jenkins | 47 | Blood courier | Newport | Ruby | Ruby Bhogal | 29 | Project manager | London Jon | Jon Jenkins | 47 | Blood courier | Newport | Terry | Terry Hartill | 56 | Retired air steward | West Midlands Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Antony | Antony Amourdoux | 30 | Banker | London Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Briony | Briony Williams | 33 | Full-time parent | Bristol Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Jon | Jon Jenkins | 47 | Blood courier | Newport Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Karen baking=> SELECT baking-> * baking-> FROM baking-> bakers a baking-> , bakers b baking-> WHERE baking-> a.baker = b.baker; baker | fullname | age | occupation | hometown | baker | fullname | age | occupation | hometown ---------+---------------------+-----+-----------------------------------+---------------+---------+---------------------+-----+-----------------------------------+--------------- Antony | Antony Amourdoux | 30 | Banker | London | Antony | Antony Amourdoux | 30 | Banker | London Briony | Briony Williams | 33 | Full-time parent | Bristol | Briony | Briony Williams | 33 | Full-time parent | Bristol Dan | Dan Beasley-Harling | 36 | Full-time parent | London | Dan | Dan Beasley-Harling | 36 | Full-time parent | London Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone | Imelda | Imelda McCarron | 33 | Countryside recreation officer | County Tyrone Jon | Jon Jenkins | 47 | Blood courier | Newport | Jon | Jon Jenkins | 47 | Blood courier | Newport Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield | Karen | Karen Wright | 60 | In-store sampling assistant | Wakefield Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds | Kim-Joy | Kim-Joy Hewlett | 27 | Mental health specialist | Leeds Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield | Luke | Luke Thompson | 30 | Civil servant/house and techno DJ | Sheffield Manon | Manon Lagrève | 26 | Software project manager | London | Manon | Manon Lagrève | 26 | Software project manager | London Rahul | Rahul Mandal | 30 | Research scientist | Rotherham | Rahul | Rahul Mandal | 30 | Research scientist | Rotherham Ruby | Ruby Bhogal | 29 | Project manager | London | Ruby | Ruby Bhogal | 29 | Project manager | London Terry | Terry Hartill | 56 | Retired air steward | West Midlands | Terry | Terry Hartill | 56 | Retired air steward | West Midlands (12 rows) baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> WHERE baking-> a.baker = b.baker; fullname | fullname ---------------------+--------------------- Antony Amourdoux | Antony Amourdoux Briony Williams | Briony Williams Dan Beasley-Harling | Dan Beasley-Harling Imelda McCarron | Imelda McCarron Jon Jenkins | Jon Jenkins Karen Wright | Karen Wright Kim-Joy Hewlett | Kim-Joy Hewlett Luke Thompson | Luke Thompson Manon Lagrève | Manon Lagrève Rahul Mandal | Rahul Mandal Ruby Bhogal | Ruby Bhogal Terry Hartill | Terry Hartill (12 rows) baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> WHERE baking-> a.baker <> b.baker; fullname | fullname ---------------------+--------------------- Antony Amourdoux | Briony Williams Antony Amourdoux | Dan Beasley-Harling Antony Amourdoux | Imelda McCarron Antony Amourdoux | Jon Jenkins Antony Amourdoux | Karen Wright Antony Amourdoux | Kim-Joy Hewlett Antony Amourdoux | Luke Thompson Antony Amourdoux | Manon Lagrève Antony Amourdoux | Rahul Mandal Antony Amourdoux | Ruby Bhogal Antony Amourdoux | Terry Hartill Briony Williams | Antony Amourdoux Briony Williams | Dan Beasley-Harling Briony Williams | Imelda McCarron Briony Williams | Jon Jenkins Briony Williams | Karen Wright Briony Williams | Kim-Joy Hewlett Briony Williams | Luke Thompson Briony Williams | Manon Lagrève Briony Williams | Rahul Mandal Briony Williams | Ruby Bhogal Briony Williams | Terry Hartill Dan Beasley-Harling | Antony Amourdoux Dan Beasley-Harling | Briony Williams Dan Beasley-Harling | Imelda McCarron Dan Beasley-Harling | Jon Jenkins Dan Beasley-Harling | Karen Wright Dan Beasley-Harling | Kim-Joy Hewlett Dan Beasley-Harling | Luke Thompson Dan Beasley-Harling | Manon Lagrève Dan Beasley-Harling | Rahul Mandal Dan Beasley-Harling | Ruby Bhogal Dan Beasley-Harling | Terry Hartill Imelda McCarron | Antony Amourdoux Imelda McCarron | Briony Williams Imelda McCarron | Dan Beasley-Harling Imelda McCarron | Jon Jenkins Imelda McCarron | Karen Wright Imelda McCarron | Kim-Joy Hewlett Imelda McCarron | Luke Thompson Imelda McCarron | Manon Lagrève Imelda McCarron | Rahul Mandal Imelda McCarron | Ruby Bhogal baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> WHERE baking-> a.baker > b.baker; fullname | fullname ---------------------+--------------------- Briony Williams | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Dan Beasley-Harling | Briony Williams Imelda McCarron | Antony Amourdoux Imelda McCarron | Briony Williams Imelda McCarron | Dan Beasley-Harling Jon Jenkins | Antony Amourdoux Jon Jenkins | Briony Williams Jon Jenkins | Dan Beasley-Harling Jon Jenkins | Imelda McCarron Karen Wright | Antony Amourdoux Karen Wright | Briony Williams Karen Wright | Dan Beasley-Harling Karen Wright | Imelda McCarron Karen Wright | Jon Jenkins Kim-Joy Hewlett | Antony Amourdoux Kim-Joy Hewlett | Briony Williams Kim-Joy Hewlett | Dan Beasley-Harling Kim-Joy Hewlett | Imelda McCarron Kim-Joy Hewlett | Jon Jenkins Kim-Joy Hewlett | Karen Wright Luke Thompson | Antony Amourdoux Luke Thompson | Briony Williams Luke Thompson | Dan Beasley-Harling Luke Thompson | Imelda McCarron Luke Thompson | Jon Jenkins Luke Thompson | Karen Wright Luke Thompson | Kim-Joy Hewlett Manon Lagrève | Antony Amourdoux Manon Lagrève | Briony Williams Manon Lagrève | Dan Beasley-Harling Manon Lagrève | Imelda McCarron Manon Lagrève | Jon Jenkins Manon Lagrève | Karen Wright Manon Lagrève | Kim-Joy Hewlett Manon Lagrève | Luke Thompson Rahul Mandal | Antony Amourdoux Rahul Mandal | Briony Williams Rahul Mandal | Dan Beasley-Harling Rahul Mandal | Imelda McCarron Rahul Mandal | Jon Jenkins Rahul Mandal | Karen Wright Rahul Mandal | Kim-Joy Hewlett baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> WHERE baking-> a.baker > b.baker baking-> and a.hometown = b.hometown ; fullname | fullname ---------------------+--------------------- Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Manon Lagrève | Antony Amourdoux Ruby Bhogal | Manon Lagrève Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Antony Amourdoux (6 rows) baking=> \d+ technicals Table "public.technicals" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description -----------+------------------------+-----------+----------+---------+----------+--------------+------------- episodeid | integer | | not null | | plain | | baker | character varying(100) | | not null | | extended | | rank | integer | | | | plain | | Indexes: "technicals_pkey" PRIMARY KEY, btree (episodeid, baker) Foreign-key constraints: "technicals_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) "technicals_episodeid_fkey" FOREIGN KEY (episodeid) REFERENCES episodes(id) Access method: heap baking=> SELECT baking-> t1.episodeid baking-> , t2.episodeid baking-> FROM baking-> technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.episodeid = t2.episodeid; episodeid | episodeid -----------+----------- 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 baking=> SELECT baking-> t1.episodeid baking-> , t2.episodeid baking-> FROM baking-> technicals t1 baking-> , technicals t2 baking-> WHERE baking-> abs(t1.rank - t2.rank) = 1 baking-> and t1.episodeid = t2.episodeid; episodeid | episodeid -----------+----------- 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 1 | 1 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 2 | 2 3 | 3 baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown ; fullname | fullname ---------------------+--------------------- Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown ; fullname | fullname ---------------------+--------------------- Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown ; fullname | fullname ---------------------+--------------------- Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown ; fullname | fullname ---------------------+--------------------- Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève baking=> \d List of relations Schema | Name | Type | Owner --------+--------------+-------+--------- public | bakers | table | kkuzmin public | episodes | table | kkuzmin public | favorites | table | kkuzmin public | results | table | kkuzmin public | showstoppers | table | kkuzmin public | signatures | table | kkuzmin public | technicals | table | kkuzmin (7 rows) baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown ; fullname | fullname ---------------------+--------------------- Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Dan Beasley-Harling | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Antony Amourdoux Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève baking=> SELECT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown baking-> and abs(t1.rank - t2.rank) = 1 baking-> and t1.episodeid = t2.episodeid; fullname | fullname ----------------+--------------------- Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Antony Amourdoux Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Manon Lagrève (9 rows) baking=> SELECT DISTINCT baking-> a.fullname, b.fullname baking-> FROM baking-> bakers a baking-> , bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> t1.baker = a.baker baking-> and t2.baker = b.baker baking-> and a.baker > b.baker baking-> and a.hometown = b.hometown baking-> and abs(t1.rank - t2.rank) = 1 baking-> and t1.episodeid = t2.episodeid baking-> ORDER BY baking-> a.fullname ASC baking-> , b.fullname DESC ; fullname | fullname ----------------+--------------------- Manon Lagrève | Dan Beasley-Harling Ruby Bhogal | Manon Lagrève Ruby Bhogal | Dan Beasley-Harling Ruby Bhogal | Antony Amourdoux (4 rows) baking=> SELECT baking-> baker as bakershortname baking-> , fullname as bakerfullname baking-> FROM baking-> bakers baking-> WHERE baking-> age >= 30; bakershortname | bakerfullname ----------------+--------------------- Antony | Antony Amourdoux Briony | Briony Williams Dan | Dan Beasley-Harling Imelda | Imelda McCarron Jon | Jon Jenkins Karen | Karen Wright Luke | Luke Thompson Rahul | Rahul Mandal Terry | Terry Hartill (9 rows) baking=> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated'; baker | fullname --------+--------------------- Imelda | Imelda McCarron Luke | Luke Thompson Antony | Antony Amourdoux Terry | Terry Hartill Karen | Karen Wright Dan | Dan Beasley-Harling Jon | Jon Jenkins Manon | Manon Lagrève Briony | Briony Williams (9 rows) baking=> ( baking(> SELECT baking(> baker as bakershortname baking(> , fullname as bakerfullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ORDER BY baking-> bakershortname baking-> ; bakershortname | bakerfullname ----------------+--------------- Rahul | Rahul Mandal Ruby | Ruby Bhogal (2 rows) baking=> ( baking(> SELECT baking(> baker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ORDER BY baking-> baker baking-> ; baker | fullname -------+-------------- Rahul | Rahul Mandal Ruby | Ruby Bhogal (2 rows) baking=> SELECT baking-> min(age) baking-> , max(age) baking-> , max(age) - min(age) as agedifference baking-> , min(hometown) baking-> FROM baking-> bakers; min | max | agedifference | min -----+-----+---------------+--------- 26 | 60 | 34 | Bristol (1 row) baking=> \d+ bakers Table "public.bakers" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ------------+------------------------+-----------+----------+---------+----------+--------------+------------- baker | character varying(10) | | not null | | extended | | fullname | character varying(100) | | | | extended | | age | integer | | | | plain | | occupation | character varying(100) | | | | extended | | hometown | character varying(100) | | | | extended | | Indexes: "bakers_pkey" PRIMARY KEY, btree (baker) Referenced by: TABLE "favorites" CONSTRAINT "favorites_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "results" CONSTRAINT "results_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "showstoppers" CONSTRAINT "showstoppers_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "signatures" CONSTRAINT "signatures_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) TABLE "technicals" CONSTRAINT "technicals_baker_fkey" FOREIGN KEY (baker) REFERENCES bakers(baker) Access method: heap baking=> SELECT baking-> min(age) baking-> , max(age) baking-> , max(age) - min(age) as agedifference baking-> , min(hometown) baking-> FROM baking-> bakers; min | max | agedifference | min -----+-----+---------------+--------- 26 | 60 | 34 | Bristol (1 row) baking=> SELECT baking-> occupation, baking-> min(age) baking-> , max(age) baking-> , max(age) - min(age) as agedifference baking-> , min(hometown) baking-> FROM baking-> bakers; ERROR: column "bakers.occupation" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: occupation, ^ baking=> SELECT baking-> b.baker baking-> , b.hometown baking-> , count(*) baking-> FROM baking-> bakers b baking-> , technicals t1 baking-> , technicals t2 baking-> WHERE baking-> b.baker = t1.baker baking-> and b.baker = t2.baker baking-> and t1.episodeid <> t2.episodeid baking-> and t1.rank = 1 baking-> and t2.rank = 1 baking-> GROUP BY baking-> b.baker baking-> , b.hometown ; baker | hometown | count --------+----------+------- Briony | Bristol | 2 Ruby | London | 6 (2 rows) baking=> SELECT baking-> t.baker baking-> , count(*) as numtechnicalwon baking-> FROM baking-> technicals t baking-> WHERE baking-> t.rank = 1 baking-> GROUP BY baking-> t.baker; baker | numtechnicalwon ---------+----------------- Dan | 1 Briony | 2 Terry | 1 Jon | 1 Rahul | 1 Kim-Joy | 1 Ruby | 3 (7 rows) baking=> SELECT baking-> t.baker baking-> , count(*) as numtechnicalwon baking-> FROM baking-> technicals t baking-> WHERE baking-> t.rank = 1 baking-> GROUP BY baking-> t.baker baking-> HAVING baking-> count(*) > 1; baker | numtechnicalwon --------+----------------- Briony | 2 Ruby | 3 (2 rows) baking=> ( baking(> SELECT baking(> baker as bakershortname baking(> , fullname as bakerfullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker as bakeshortname baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ORDER BY baking-> bakershortname baking-> ; bakershortname | bakerfullname ----------------+--------------- Rahul | Rahul Mandal Ruby | Ruby Bhogal (2 rows) baking=> ( baking(> SELECT baking(> baker as bakershortname baking(> , fullname as bakerfullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ORDER BY baking-> b.baker baking-> ; ERROR: missing FROM-clause entry for table "b" LINE 35: b.baker ^ baking=> ( baking(> SELECT baking(> baker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ORDER BY baking-> baker baking-> ; baker | fullname -------+-------------- Rahul | Rahul Mandal Ruby | Ruby Bhogal (2 rows) baking=> ( baking(> SELECT baking(> baker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker as mybaker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ORDER BY baking-> mybaker baking-> ; ERROR: column "mybaker" does not exist LINE 35: mybaker ^ HINT: There is a column named "mybaker" in table "*SELECT* 3", but it cannot be referenced from this part of the query. baking=> ( baking(> SELECT baking(> baker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker as mybaker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ; baker | fullname -------+-------------- Ruby | Ruby Bhogal Rahul | Rahul Mandal (2 rows) baking=> ( baking(> SELECT baking(> baker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> ORDER BY mybaker baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker as mybaker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ; ERROR: syntax error at or near "UNION" LINE 10: UNION ^ baking=> ( baking(> SELECT baking(> baker mybaker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> ORDER BY mybaker baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> ; ERROR: syntax error at or near "UNION" LINE 10: UNION ^ baking=> ( baking(> SELECT baking(> baker mybaker baking(> , fullname baking(> FROM baking(> bakers baking(> WHERE baking(> age >= 30 baking(> baking(> UNION baking(> baking(> SELECT baking(> b.baker baking(> , b.fullname baking(> FROM baking(> bakers b baking(> , technicals t1 baking(> , technicals t2 baking(> WHERE baking(> b.baker = t1.baker baking(> and b.baker= t2.baker baking(> and t1.episodeid <> t2.episodeid baking(> and t1.rank = 1 baking(> and t2.rank = 1 baking(> ) baking-> baking-> EXCEPT baking-> baking-> SELECT baking-> b.baker baking-> , b.fullname baking-> FROM baking-> bakers b baking-> , results r baking-> WHERE baking-> b.baker = r.baker baking-> and r.result = 'eliminated' baking-> baking-> ORDER BY mybaker baking-> ; mybaker | fullname ---------+-------------- Rahul | Rahul Mandal Ruby | Ruby Bhogal (2 rows) baking=>