From the erd below, create a subquery that refers to the questions below. Note : The data type in the ComputerBrandName should be varchar(100) Because there is a little typo.

1 Computer Brand PK IDComputerBrand char(6) FK ComputerBrandName Type Computer PK IDComputer char(6) FK IDComputerBrand char(6) ComputerName varchar(100) Computer Type varchar(100) Computer Price int 1. * 1 1.. Client PK IDClient char(6) FK IDComputer char(6) ClientName varchar(100) ClientDateOfBirth date ClientGender varchar(100) ClientEmail varchar(100) ClientAddress varchar(100) Question Database SQL Subquery Show (use SELECT in SELECT and Join) IDComputerBrand, ComputerBrandName, ID Client, ClientEmail (get from replace format email to '@rocketmail.com'), Quantity (get from sum Quantity of computers of the Brand) for the highest Quantity of the brand, client that has the email format '@yahoo.com' and IDClient ending in odd number. Please provide a screenshot of the proof of the query that has been made in the database view