A member's last name and first name in that order.
Book, Journal Article, Conference Paper
Publication types, where the type is 'B', 'A', or 'P'
respectively.
broad expertise
A broad expertise is an expertise that is part of the
keyword table. ex: 12 - Military History
narrow expertise
A narrow expertise is an expertise that is part of the
supp_key table. ex: 3 - Treaty Organizations
List the full names of Members who have a broad expertise in Military
History. Sort the results by full name.
Count the number of Members who have a broad expertise in Military
History.
List the full names of Members who have a narrow expertise in Treaty
Organizations. Sort the results by full name.
Count the number of Members who have a narrow expertise in Treaty
Organizations.
List the full names of Members who are associated with Wilfrid Laurier
University. Sort the results by full name.
Count the number of Members who are associated with Wilfrid Laurier
University.
List the narrow expertises that belong to the Military History broad
expertise. Sort the results by description.
Count the number of narrow expertises that belong to the Military
History broad expertise.
List the full names (once) of all Members who have published Books.
Sort the results by full name.
Count the number of Members who have published Books. Each Member
should be counted only once.
List the titles and publishers of all books published by Members. Sort
the results by publisher.
List the titles of all books published by Members with a broad
expertise in Military History. Sort the results by publication title.
Count the number of books published by Members with a broad expertise
in Military History.
List the full name of Members and titles of their publications where
the title refers to 'Canada'. (Does not need to look for alternatives such
as 'Canadian'.) Sort the results by publication title within full
name.
Count the number of publications where its title refers to Canada.
(Does not need to look for alternatives such as 'Canadian'.)
List the title and publication date of all publications published after
1999. Sort the results by title within date.
Count the number of publications published after 1999.
Count the number of narrow expertises that are not held by any
Member.
List the descriptions of all narrow expertises that are not held by any
Member. Sort the results by description.
List the full name of each Member and number of publications of each
Member. Sort the results by full name within number of publications from
most to least.
List the full names and number of broad expertises of each Member. Sort
the results by full name within the number of broad expertises from most to
least.
List the full names and number of narrow expertises of each Member.
Sort the results by full name within the number of narrow expertises from
most to least.
List each broad expertise and the number of Members who have that
expertise. Sort the results by expertise description.
List each narrow expertise and the number of Members who have that
expertise. Sort the results by expertise description.
List the full name of each Member and the number of articles written by
each Member. Sort the results by full name.
List the full name of the Member and number of books written by each
Member who is connected to Wilfrid Laurier University. Sort the results by
full name.
Count the number of each type (book, article, or paper) of publication.
Sort the results by the full type name.
List the full names of Members who have a broad expertise in Military
History and a narrow expertise in Treaty Organizations. Sort the results by
full name.
Count the number of publications by each publisher. Sort the results by
publisher.
Count the number of publications published since 1999 grouped by
publication date. Sort the results by publication date.
List the full names of Members who have a broad expertise in Military
History and do not have a narrow expertise in Treaty Organizations. Sort
the results by full name.
List the full names of all Members and the number of Books, Articles,
and Papers each Member owns. Sort the results by full name.
List the full names of Members and the titles of their Publications
where the publication title contains the word "war" but the Member does not
have a Military History broad expertise.
Sort the results by publication title within name.
List the full names of all Members and the number of broad and narrow
expertises each has. Sort the results by full name.
List the full names of Members whose only narrow expertise is in
Northeast Asia. Sort the results by full name.
List the full names of all Members who have not published Books. Sort
the results by full name.
List the full names of all Members who published only Books. Sort the
results by full name.
List the full names of all Members who have more than three
publications. Sort the results by full name.
List the full names and number of broad expertises of all Members who
have fewer than three broad expertises. Sort the results by full name.