Question

Select all rows from the new table you''ve just created (there should only be the two rows you just inserted!).
Order the output by your table''s primary key; format all columns using CAST, CONVERT and/or STR.

Answer 1

Let us create a Table called "SampleTable"

CREATE TABLE SampleTable
(
ID INT NOT NULL PRIMARY KEY,
FirstName VARCHAR(30) NOT NULL,
LastName VARCHAR(30) NOT NULL
);

Now we need to insert data into this table.
Sql 1:-

INSERT INTO SampleTable VALUES (1, 'Stephen', 'Jiang');

Sql 2 :-

INSERT INTO SampleTable (ID, FirstName, LastName) VALUES (2, 'Avinash', 'kotina');

data in the table :-
-------------------
1, 'Stephen', 'Jiang'
2, 'Avinash', 'kotina'

Select all rows from the new table you''ve just created (there should only be the two rows you just inserted!).
Order the output by your table''s primary key; format all columns using CAST, CONVERT and/or STR.

select * from SampleTable Orderby ID;

data after the above sql executed will be :-
-------------------
1, 'Stephen', 'Jiang'
2, 'Avinash', 'kotina'

SELECT FIRSTNAME, CAST(ID AS Float) Float_ID FROM SampleTable;

Now ID filed will be casted/convereted to Float

data after the above sql executed will be :-
-------------------
1.0, 'Stephen', 'Jiang'
2.0, 'Avinash', 'kotina'