Question

create table country ( name varchar(60), isocode3 char(3), population integer, indepyear smallint default 0, area decimal(9, 2) default 1.0, tld char(3), primary key (name) );

Answer 1

The Newerth's Area is 1.0

The Newerth's IndepYear is None (NULL )

The Newerth's ISOCode2 is AA

What is the code about?

Newerth's Area is 1.0 due to the fact that it is the default value specified in the CREATE TABLE statement. Newerth's IndepYear is None.

In terms of the New area, Since no specific value for the "Area" column is provided in the INSERT statement, the default value of 1. 0 is so one can say that, the area of ​​Newerth is 1. 0

Therefore, Column 'ISOCode2' is one that has a default value of 'AA', which will be used if no specific value is given in the INSERT statement. So Newerth's ISOCode2 is said to be “AA”.

See text below

Show the code behind this result

A row is inserted into Country with Name 'Newerth but with no other values specified.

What is Newerth's Area?

What is Newerth's IndepYear?

What is Newerth's ISOCode2?