CREATE TABLE news_report (journalist_id NUMBER, event_id NUMBER, work_type CLOB)
CREATE TABLE event (event_id NUMBER, date CLOB, venue CLOB, name CLOB, event_attendance NUMBER)
CREATE TABLE journalist (journalist_id NUMBER, name CLOB, nationality CLOB, age CLOB, years_working NUMBER)

Show the different nationalities and the number of journalists of each nationality.
SELECT nationality, COUNT(*) FROM journalist GROUP BY nationality
SELECT "nationality", COUNT(*) FROM "journalist" GROUP BY "nationality"