Answer Happy

III.
CREATE TABLE ahmed_customers_accounts (id SERIAL PRIMARY
KEY,
first_name VARCHAR(30),
last_name VARCHAR(40),
bank_account_number VARCHAR(50),
paypal_email VARCHAR(50),
venmo_email VARCHAR(50),
created_at DATE);
CREATE TABLE ahmed_stocks (id
INTEGER REFERENCES ahmed_customers_accounts(id),symbol
CHAR(10),price real,last_updated_at DATE);
INSERT INTO
ahmed_customers_accounts(id, first_name, last_name,
bank_account_number, paypal_email, venmo_email)
VALUES(1, 'ann_mkmkn',
'akjned', '38568765'
,'[email protected]','[email protected]'),
(2, 'Joseph', 'James',
'23457698','[email protected]','[email protected]'),
(3, 'Mary', 'Johnsy',
'2345767698','[email protected]','[email protected]'),
(4, 'Mike', 'Magesh',
'2365988809','[email protected]','[email protected]'),
(5, 'Peter', 'Paul',
'2344546705','[email protected]','[email protected]'),
(6, 'Lemma', 'Lisa',
'23459087','[email protected]','[email protected]'),
(7, 'Jacob', 'James',
'23908745','[email protected]','[email protected]'),
(8, 'Jacos', 'dames',
'021000021','[email protected]','[email protected]'),
(9, 'Micak', 'Malini',
'NULL','NULL','NULL'),
(10, 'Ruth', 'Roven',
'NOT NULL','NOT NULL','NOT NULL');
INSERT INTO ahmed_stocks(id, symbol,
price, last_updated_at)
VALUES(1,'est',10,'2015-04-09'),
(2,'dollar',20,'2015-04-09'),
(3,'egp',30,'2015-04-09'),
(4,'yen',40,'2015-10-09'),
(5,'lera',50,'2015-12-09');
QUESTION
2.