Create the table and columns
-- Input data (rows) in the table
-- Select and display all data from the table
To create a table and columns, you can use the following SQL syntax:
```sql
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
...
);
```
You can replace `table_name` with your desired table name, and `column1`, `column2`, `column3`, etc. with the column names you want in your table.
To input data (rows) into the table, you can use the following SQL syntax:
```sql
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
```
Replace `table_name` with the name of your table, and `column1`, `column2`, `column3`, etc. with the column names you want to populate with values. Also, replace `value1`, `value2`, `value3`, etc. with the respective values you want to insert.
To select and display all the data from the table, you can use the following SQL syntax:
```sql
SELECT * FROM table_name;
```
Replace `table_name` with the name of your table. The `*` selects all columns in the table.
Once you have created the table, inserted the data, and run the select query, the result will be displayed, showing all the data present in the table.