Question

Note: The data type of ISSN, ISSN Online, and Field of Research are short texts. The data type of Year inception is a number. 1) List Journal title and publisher that the journal title starts with a letter a through c. Use wild card. 2) List Journal title, ISSN, and Year inception that the year inception was done before 2000. 3) List journal title and publisher that publisher's name starts with a letter between C and G (including C but not including G). 4) List journal title, publisher, ISSN, Field of research, and rating that rating is either B or C. 5) List journal title, publisher, and rating that rating is A. 6) List publisher and the count per publisher. (Hint: Use group by) 7) List rating and count per rating (i.e. how many are in the category of A, A, B, or C) (Hint: Use group by) 8) List journal title, publisher, and year inception that was incepted first. 9) List publisher and year inception that year inception is first per publisher (Hint: use group by) 10) List journal title, publisher, year inception, and message. The message should contain 'Before 2000' if a journal was incepted before 2000. Otherwise, 'After 2000'. (Hint: Use iif)

          Note: The data type of ISSN, ISSN Online, and Field of Research are short texts. The data type
of Year inception is a number.
1) List Journal title and publisher that the journal title starts with a letter a through c. Use
wild card.
2) List Journal title, ISSN, and Year inception that the year inception was done before 2000.
3) List journal title and publisher that publisher's name starts with a letter between C and
G (including C but not including G).
4) List journal title, publisher, ISSN, Field of research, and rating that rating is either B or C.
5) List journal title, publisher, and rating that rating is A*.
6) List publisher and the count per publisher. (Hint: Use group by)
7) List rating and count per rating (i.e. how many are in the category of A, A*, B, or C) (Hint:
Use group by)
8) List journal title, publisher, and year inception that was incepted first.
9) List publisher and year inception that year inception is first per publisher (Hint: use
group by)
10) List journal title, publisher, year inception, and message. The message should contain
'Before 2000' if a journal was incepted before 2000. Otherwise, 'After 2000'. (Hint: Use
iif)

Note: The data type of ISSN, ISSN Online, and Field of Research are short texts. The data type
of Year inception is a number.
1) List Journal title and publisher that the journal title starts with a letter a through c. Use
wild card.
2) List Journal title, ISSN, and Year inception that the year inception was done before 2000.
3) List journal title and publisher that publisher's name starts with a letter between C and
G (including C but not including G).
4) List journal title, publisher, ISSN, Field of research, and rating that rating is either B or C.
5) List journal title, publisher, and rating that rating is A*.
6) List publisher and the count per publisher. (Hint: Use group by)
7) List rating and count per rating (i.e. how many are in the category of A, A*, B, or C) (Hint:
Use group by)
8) List journal title, publisher, and year inception that was incepted first.
9) List publisher and year inception that year inception is first per publisher (Hint: use
group by)
10) List journal title, publisher, year inception, and message. The message should contain
'Before 2000' if a journal was incepted before 2000. Otherwise, 'After 2000'. (Hint: Use
iif)

Added by Timothy G.

Question

Please give Ace some feedback