Database Diagrams for the Order Entry Database

Write atatements using pgAdmin for PostgreSQL:

Problem $7$: List the order number, order date, employee number, employee name $($first

and last$),$ customer number, customer name $($first and last$),$ product number, product

name, and manufacturer of orders placed on January $23,2021.$ List the order even if

there is not an associated employee. Order the result by order number and product

number.

Problem $8$: For problem $7,$ show a different order of operations in the FROM clause from

your answer to Problem $7.$