Hello NQE Enthusiasts,
Another challenge.
Challenge
Passport Task
Let’s assume you are an agent of Customs and Border Protection (CBP) and are working a border crossing from the US into Canada. Citizens from the US and Canada DO NOT need a passport to cross the border. Assume for this scenario that all other nationals do require a passport.
Write an NQE query that returns the people in the list that require a passport, and who they are and where they are from.
Input:
List of people crossing
Bob Smith - US
Zhang Wei - China
Hiromasa Tahara - Japan
Jessica Northland - Canada
Wess Maple - Canada
Peter Volkman - Germany
Jeremy Clarkson- UK
Rachel Riley - UK
Scott Ramirez - Spain
Gabriel Martin - France
Kazuko Hashigawa - Japan
Thomas Bouchard - Canada
Hint: Use lists (item in list) and Comparisons
Contributions: John Schupp
