on a macbook

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 TotalAssets2021' 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. 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 TotalAssets2021' 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