I have a question about this fiddle: <>https://dbfiddle.uk?rdbms=mysql_8.0&fiddle=a88f9e630eea7f3f11b963d54a2af732
I have a question about this fiddle: <>https://dbfiddle.uk?rdbms=mysql_8.0&fiddle=a88f9e630eea7f3f11b963d54a2af732
@Anonymous, re: [your question](#question), don't know about others but to me it's not very clear what the expected output should be. It would be easier to see what you are trying to do if you included aircraft companies into your example and actually showed the desired output (you could construct it as a regular table for the sake of demonstration)