b$)$ Copy the query from $1.$a but edit it to show only record in the year of $2020.$ Also submit a screenshot of output of $1.$b$.$

$2)$ INNER JOIN, WHERE, GROUP, and HAVING:

a$)$ Using the Data$\_$Environmental and Data$\_$Comp tables, show PERMNO, CONAME, fiscal year $($from the Data$\_$Environmental table$),$ and total assets $($AT$)($from the Data$\_$Comp table$).$

b$)$ Copy and paste the query from $2.$a but filter the results so that only fiscal year $2021$ is displayed. Store this query as a view called $$TotalAssets$2021.$

c$)$ Use the $$TotalAssets$2021$ view created in $2.$b to only show companies with total assets greater than $$100,000,000($amounts in database are in thousands$).$ Also submit a screenshot of $2.$c output.

$3)$ LEFT JOIN $($same as LEFT OUTER JOIN$)$:

a$)$ Left joining the DATA$\_$CEO and DATA$\_$Environmental tables. Display: PERMNO, the CEO$$s first and last names, Salary $($from the Data$\_$CEO table$),$ company name $($from the Data$\_$Environmental table$).$ Link the tables on PERMYR. Also submit a screenshot of output.

$4)$ INNER JOINS: Join three tables $($optional$,5$ extra points$)$:

Using Data$\_$CEO, Data$\_$Environmental, and Data$\_$Comp tables, show PERMNO, the company$$s name $($CONAME$),$ the CEO$$s first and last name, the CEO$$s salary, the company$$s total revenue $($REVT$),$ and the fiscal year $($FYEAR$).$ Filter the results so that only fiscal year $2021$ is displayed. Also submit a screenshot of output.