WRITE RELATIONAL ALGEBRA

1- Which country has maximum users and limit it by 1

SELECT country,count(id) FROM google_account GROUP BY country ORDER BY count(id) desc LIMIT 1;

2-Display gender based on the user subscription.

select count(a.id) as Num_of_subscribers,a.gender from google_account a inner join user_subscription b on a.id=b.google_account_id group by a.gender;

3-What is the url for oldest video, Display url with date and time.

select url,upload_timestamp from video where upload_timestamp=(select min(upload_timestamp) from video);

4-Show the contact details and date of birth of youngest male user.

select fullname,email,country,birthdate from google_account where birthdate=(select max(birthdate) from google_account where gender='M');