Hello! Help with SQL$,$ please!

We have following tables from database $\_$adventureworkslt:

CREATE TABLE public.product $($

productid serial$4$ NOT NULL,

"name" varchar$(50)$ NOT NULL,

productnumber varchar$(25)$ NOT NULL,

color varchar$(15)$ NULL,

listprice numeric$(29,3)$ NOT NULL,

"size" varchar$(5)$ NULL,

sizeunitmeasurecode bpchar NULL,

weightunitmeasurecode bpchar NULL,

weight numeric$(8,2)$ NULL,

productline bpchar NULL,

"class" bpchar NULL,

"style" bpchar NULL,

productsubcategoryid int$4$ NULL,

productmodelid int$4$ NULL,

sellstartdate timestamp$(6)$ NOT NULL,

sellenddate timestamp$(6)$ NULL,

discontinueddate timestamp$(6)$ NULL,

CONSTRAINT product$\_$pkey PRIMARY KEY $($productid$)$

$)$;

CREATE INDEX idx$\_$product$\_$color ON public.product USING btree $($color$)$;

CREATE TABLE public.productsubcategory $($

productsubcategoryid serial$4$ NOT NULL,

productcategoryid serial$4$ NOT NULL,

"name" varchar$(54)$ NOT NULL,

CONSTRAINT productsubcategory$\_$pkey PRIMARY KEY $($productsubcategoryid$)$

$)$;

CREATE TABLE public.productcategory $($

productcategoryid serial$4$ NOT NULL,

"name" varchar$(54)$ NOT NULL,

CONSTRAINT productcategory$\_$pkey PRIMARY KEY $($productcategoryid$)$

$)$;

CREATE TABLE public.customer $($

customerid int$4$ NOT NULL,

namestyle bool DEFAULT false NOT NULL,

title varchar$(8)$ NULL,

firstname varchar$(50)$ NULL,

middlename varchar$(50)$ NULL,

lastname varchar$(50)$ NULL,

suffix varchar$(10)$ NULL,

companyname varchar$(128)$ NULL,

emailaddress varchar$(50)$ NULL,

rowguid varchar$(36)$ NOT NULL,

modifieddate timestamp$(6)$ DEFAULT CURRENT$\_$TIMESTAMP NOT NULL,

salespersonid int$4$ NULL,

gender varchar$(1)$ NULL,

totalchildren int$4$ NULL,

birthdate date NULL,

datefirstpurchase date NULL,

persontype varchar$(3)$ NULL,

CONSTRAINT customer$\_$pkey PRIMARY KEY $($customerid$)$

$)$;

CREATE TABLE public.customeraddress $($

customerid int$4$ NOT NULL,

addressid int$4$ NOT NULL,

addresstype varchar$(50)$ NOT NULL,

modifieddate timestamp$(6)$ DEFAULT CURRENT$\_$TIMESTAMP NOT NULL,

CONSTRAINT customeraddress$\_$pk PRIMARY KEY $($customerid$,$ addressid, addresstype$)$

$)$;

ALTER TABLE public.customeraddress ADD CONSTRAINT customeraddress$\_$c$\_$fk FOREIGN KEY $($customerid$)$ REFERENCES public.customer$($customerid$)$;

ALTER TABLE public.customeraddress ADD CONSTRAINT customeraddress$\_$fk FOREIGN KEY $($addressid$)$ REFERENCES public.address$($addressid$)$;

Add two materialized views $$product$2,$country$2.$ Product$2$ should combine data of product and

its category. Country$2$ view should be filled with unique codes of the countries where the shops are

located $($country codes can be taken from addresses of $$Main Office$$ type$($addresstype$)).$

Allow managers and administrators to read from these views.

Fields of $$product$2$ are shown in the table. Each field to be included in the view is described below:

Field Description Rule

$----------------------------------------------------------------------------$

pcid $|$Product category key $|$Load from Productcategory.productcategoryid

productid $|$Product key $|$Load from Product.productid

pcname $|$Category name $|$Load from Productcategory.name

pname $|$Product name $|$Load from Product.name

Fields of 'country$2\text{'}$ are shown in the table:

Field Description Rule

$----------------------------------------------------$

countrycode $|$Code of country $|$Load unique values from customeraddress.countreyregioncode

Make sure your query reads only $$Main Office$$ addresses $($addresstype$)$