Clarification #1: Oracle does not have a native boolean type, you should use char(1) for the is_captain field.
Clarification #2: to_date is not part of the primary key, so it can be NULL. The updated schema reflects this change.
Clarification #3: you should submit three separate plain text files: query1.sql, query2.sql, and query3.sql
New comments are not allowed.
Clarification #1: Oracle does not have a native boolean type, you should use char(1) for the is_captain field.
ReplyDeleteClarification #2: to_date is not part of the primary key, so it can be NULL. The updated schema reflects this change.
ReplyDeleteClarification #3: you should submit three separate plain text files: query1.sql, query2.sql, and query3.sql
ReplyDelete