Here is how I would write the answer to **Puzzle 123** in SQL:


CREATE TABLE Germans (
German_name VARCHAR(256) PRIMARY KEY
);

CREATE TABLE Italians (
Italian_name VARCHAR(255) PRIMARY KEY
);

CREATE TABLE German_Italian_friend_of_join (
German_name VARCHAR(255) REFERENCES Germans(German_name) NOT NULL,
friend_of VARCHAR(255) REFERENCES Italians(Italian_name) NOT NULL,
Primary Key (German_name, friend_of)
);

CREATE TABLE Italian_German_friend_of_prime_join (
Italian_name VARCHAR(255) REFERENCES Italians(Italian_name) NOT NULL,
friend_of_prime VARCHAR(255) REFERENCES Germans(German_name) NOT NULL,
Primary Key (Italian_name, friend_of_prime)
);


Is Ryan Wisnesky around? I am extremely curious what SQL the FQL system should compile to in this case.