SQL Tutorials - Creation of tables

In the SQL Tutorials, you have given the below assignment to create a table with structure but the creation of these is not taught. Can you please explain how to create it-
image

please help

Thank you