For this Question: Join the user table with the post such that we get the list of all users with their posts such that the users who didn’t post anything contains NULL for the corresponding post fields. The fields in the final table should be (username, full_name, post_title).

<schema>[{'name': 'profile', 'columns': [{'name': 'username', 'type': 'varchar (24)'}, {'name': 'full_name', 'type': 'varchar (72)'}, {'name': 'headline', 'type': 'varchar (72)'}]},{'name': 'post', 'columns': [{'name': 'id', 'type': 'int'}, {'name': 'username', 'type': 'varchar(24)'}, {'name': 'post_title', 'type': 'varchar (72)'}, {'name': 'post_description', 'type': 'text'}, {'name': 'datetime_created', 'type': 'datetime'}, {'name': 'number_of_likes', 'type': 'int'}, {'name': 'photo', 'type': 'blob'}]}]</schema>nannannan, I have written this Solution Code: SELECT profile.username, full_name, post_title FROM profile LEFT JOIN post on profile.username = post.username , In this Programming Language: SQL, Now tell me if this Code is compilable or not?