Country

$$ ISOCode$3$ ISOCode$2$ PopDensity Population

ESP ES $242\mathrm{.}646800000$

QAT QA $620\mathrm{.}52780000$

GHA GH $338\mathrm{.}829770000$

Statistics

$$ TLD Code$3$ Capital Area

$.$es ESP Madrid $192900$

$.$qa QAT Doha $4500$

$.$gh GHA Accra $87900$

An arrow points from the Statistics table's Code$3$ column to the Country table's primary key column.CREATE TABLE Statistics $($

Code$3$ CHAR$(3),$

TLD CHAR$(3),$

Capital VARCHAR$(15),$

Area DECIMAL$(9,2),$

PRIMARY KEY $($TLD$),$

FOREIGN KEY $($Code$3)$

REFERENCES Country$($ISOCode$3)$

ON DELETE CASCADE

ON UPDATE RESTRICT

$)$;The CREATE TABLE statement above creates the Statistics table. What is the result of each operation?Deleting the row containing QA from the Country table.

Select

Updating the ISOCode$3$ of QA from QAT to XYZ$.$

Select

Deleting the foreign key QAT from the Statistics table.