Procedure
-
Double-click TotalScoreOfPreferredSubject
to open its Basic settings view.
- In the Default Table Name field, enter an output table name. In this example, it is TotalScoreOfPreferredSubject.
-
Click the [...] button next to Edit schema to define the schema of the output table
in the schema editor.
Click the [+] button to add four columns, SeqID and TotalScore with the DB Type set to INTEGER, StuName and PreferredSubject with the DB Type set to VARCHAR.Click OK to validate these changes and close the schema editor.