Answer:
We can use CREATE command to create tables with columns having descriptive names
Explanation:
Firstly, create a table using CREATE command in SQL. The syntax is as follows:
CREATE TABLE [table_name]
(
[col_name] [datatype]),
[col_name] [datatype]),
[col_name] [datatype]),
[col_name] [datatype])
)
Once the table is created, we can insert the data into table using INSERT command. It's syntax is as follows:
INSERT INTO table_name VALUES('', '', '')
if datatype is string, values must be entered within single quotes. If datatype is int, values are entered directly without using quotes.
Now, you can select the data from the table using SELECT command. It's syntax is as follows:
SELECT column-list FROM table_name
If you want to filter rows according to conditions, you can use WHERE command.
I have created sample table and inserted some data into it. Now, I applied some queries on it to select data from the table.
I have written in a text file and attached the same. Please find. Thank you!
