Needing help with my SQL $($for Postgres$).$ Errors at end. Tasks:

$1.$ What is the full name, full address, title, and phone number for all employees currently living in a US state that shares a border with the Pacific Ocean?

$2.$ Give the same information for all employees not in the USA but are older than $50$ years of age.

$3.$ Which employees $($last name, first name without repeats$)$ have placed orders delivered to Norway?

$4.$ What is the title and name of any employee that has sold at least two of either "Vegie$-$spread" or "Sir Rodney$$s Marmalade"?

$5.$ hat are the Employee IDs for all employees who have sold more than $70$ products?

$6.$ List the last name of all employees that live on the same city as their managers.

$7.$ List the product names of all products that were bought OR sold by people who live in London $($use a UNION$).$

$8.$What is the average price of products for each category? Output just the average price as "average$\_$price" and the category ID$.$

Script:

$--$ Question $1$: Full name, full address, title, and phone number for employees living in a US state bordering the Pacific Ocean

SELECT CONCAT$($first$\_$name, $\text{'}\text{'},$ last$\_$name$)$ AS full$\_$name,

CONCAT$($address$,\text{'},\text{'},$ city, $\text{'},\text{'},$ region, $\text{'}\text{'},$ postal$\_$code$)$ AS full$\_$address,

title,

phone$\_$number

WHERE country $=$ 'USA'

AND region IN $(\text{'}$Washington$\text{'},$ 'Oregon', 'California', 'Alaska', 'Hawaii'$)$;

$--$ Question $2$: Full name, full address, title, and phone number for employees not in the USA but older than $50$

SELECT CONCAT$($first$\_$name, $\text{'}\text{'},$ last$\_$name$)$ AS full$\_$name,

CONCAT$($address$,\text{'},\text{'},$ city, $\text{'},\text{'},$ region, $\text{'}\text{'},$ postal$\_$code$)$ AS full$\_$address,

title,

phone$\_$number

FROM employees

WHERE country $!=$ 'USA'

AND age $>50$;

$--$ Question $3$: Employees $($last name, first name without repeats$)$ who have placed orders delivered to Norway

SELECT DISTINCT last$\_$name, first$\_$name

FROM employees e

JOIN orders o ON e$.$employee$\_$id $=$ o$.$employee$\_$id

JOIN customers c ON o$.$customer$\_$id $=$ c$.$customer$\_$id

WHERE c$.$country $=$ 'Norway';

$--$ Question $4$: Title and name of employees who have sold at least two of "Vegie$-$spread" or "Sir Rodney$$s Marmalade"

SELECT title, CONCAT$($first$\_$name, $\text{'}\text{'},$ last$\_$name$)$ AS employee$\_$name

FROM employees e

JOIN orders o ON e$.$employee$\_$id $=$ o$.$employee$\_$id

JOIN order$\_$details od ON o$.$order$\_$id $=$ od$.$order$\_$id

JOIN products p ON od$.$product$\_$id $=$ p$.$product$\_$id

WHERE p$.$product$\_$name IN $(\text{'}$Vegie$-$spread', 'Sir Rodney$$s Marmalade'$)$

GROUP BY e$.$employee$\_$id

HAVING COUNT$(*)>=2$;

$--$ Question $5$: Employee IDs for employees who have sold more than $70$ products

SELECT employee$\_$id

FROM orders

GROUP BY employee$\_$id

HAVING SUM$($quantity$)>70$;

$--$ Question $6$: Last name of employees living in the same city as their managers

SELECT e$.$last$\_$name

FROM employees e

JOIN employees m ON e$.$reports$\_$to $=$ m$.$employee$\_$id

WHERE e$.$city $=$ m$.$city;

$--$ Question $7$: Product names bought or sold by people who live in London $($using UNION$)$

$($SELECT p$.$product$\_$name

FROM products p

JOIN order$\_$details od ON p$.$product$\_$id $=$ od$.$product$\_$id

JOIN orders o ON od$.$order$\_$id $=$ o$.$order$\_$id

JOIN customers c ON o$.$customer$\_$id $=$ c$.$customer$\_$id

WHERE c$.$city $=$ 'London'$)$

UNION

$($SELECT p$.$product$\_$name

FROM products p

JOIN customer$\_$demographics cd ON p$.$product$\_$id $=$ cd$.$product$\_$id

JOIN customers c ON cd$.$customer$\_$id $=$ c$.$customer$\_$id

WHERE c$.$city $=$ 'London'$)$;

$--$ Question $8$: Average price of products for each category

SELECT AVG$($unit$\_$price$)$ AS average$\_$price, category$\_$id

FROM products

GROUP BY category$\_$id;

Errors:

Unable to resolve column 'phone$\_$number' :$5$

Unable to resolve column 'phone$\_$number' :$14$

Unable to resolve column 'age' :$17$

Unable to resolve column 'quantity' :$40$

Unable to resolve column 'product$\_$id$\text{'}$ :$58$

Unable to resolve column 'customer$\_$id$\text{'}$ :$59$

Thanks in advance!