Question 6:
CREATE TABLE
COPY 5
 symbol | n_shares | date_acquired 
--------+----------+---------------
 AAPL   |       10 | 2026-01-15
 MSFT   |       20 | 2026-02-10
 GOOG   |        5 | 2026-03-21
 NVDA   |        8 | 2026-04-12
 META   |       12 | 2026-05-05
(5 rows)

Question 7:
(Part A)
SELECT 5
 symbol | quote_date | price  
--------+------------+--------
 META   | 2026-09-19 | 31.415
 MSFT   | 2026-09-19 | 31.415
 GOOG   | 2026-09-19 | 31.415
 NVDA   | 2026-09-19 | 31.415
 AAPL   | 2026-09-19 | 31.415
(5 rows)

(Part B)
CREATE TABLE
INSERT 0 3
 symbol | n_shares | date_acquired 
--------+----------+---------------
 GOOG   |        5 | 2026-03-21
 NVDA   |        8 | 2026-04-12
 META   |       12 | 2026-05-05
(3 rows)

Question 8:
 symbol | n_shares | price_per_share | current_value 
--------+----------+-----------------+---------------
 AAPL   |       10 |          31.415 |       314.150
 MSFT   |       20 |          31.415 |       628.300
 GOOG   |        5 |          31.415 |       157.075
 NVDA   |        8 |          31.415 |       251.320
 META   |       12 |          31.415 |       376.980
(5 rows)

Question 9:
INSERT 0 1
 symbol | n_shares | price_per_share | current_value 
--------+----------+-----------------+---------------
 AAPL   |       10 |          31.415 |       314.150
 MSFT   |       20 |          31.415 |       628.300
 GOOG   |        5 |          31.415 |       157.075
 NVDA   |        8 |          31.415 |       251.320
 META   |       12 |          31.415 |       376.980
 AIT    |       15 |                 |              
(6 rows)

Question 10:
(Part A)
CREATE FUNCTION
 stock_value 
-------------
         216
(1 row)

UPDATE 5
 symbol | quote_date |  price  
--------+------------+---------
 META   | 2026-09-19 | 295.000
 MSFT   | 2026-09-19 | 314.000
 GOOG   | 2026-09-19 | 300.000
 NVDA   | 2026-09-19 | 297.000
 AAPL   | 2026-09-19 | 286.000
(5 rows)

(Part B)
CREATE FUNCTION
 portfolio_value 
-----------------
       16556.000
(1 row)

Question 11:
INSERT 0 2
 symbol | total_share 
--------+-------------
 META   |          12
 AIT    |          15
 MSFT   |          40
 GOOG   |          10
 NVDA   |           8
 AAPL   |          10
(6 rows)

 symbol | total_shares | price_per_share | total_current_value 
--------+--------------+-----------------+---------------------
 AAPL   |           10 |         286.000 |            2860.000
 META   |           12 |         295.000 |            3540.000
 GOOG   |           10 |         300.000 |            3000.000
 MSFT   |           40 |         314.000 |           12560.000
 NVDA   |            8 |         297.000 |            2376.000
(5 rows)

Question 12:
CREATE VIEW
 symbol | total_shares | total_current_value 
--------+--------------+---------------------
 GOOG   |           10 |            3000.000
 MSFT   |           40 |           12560.000
(2 rows)